Questions with the greatest number of answers

0

Please login or register to vote for this query.

(click on this box to dismiss)

Science Fiction and Fantasy Meta

Q&A about the site for science fiction and fantasy enthusiasts

select
   ParentId as [Question ID],
   count(*) as [Number of answers]
from Posts Answer
where Answer.PostTypeId = 2
group by Answer.ParentId
order by count(*) desc;

Enter Parameters

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