select (select count(*)from Posts where AcceptedAnswerId ...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Writers

Q&A for the craft of professional writing, including fiction, non-fiction, technical, scholarly, and commercial writing

select
(select count(*)from Posts
  where AcceptedAnswerId is null
  and AnswerCount > 0
) as "No Accepted Answer",
(select count(*) from Posts
  where AnswerCount > 0
) as "Total Answered"

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results