Q&A about the site for science fiction and fantasy enthusiasts
select Question.Id as [Question ID], count(*) as [Number of answers], Question.Title as [Question Title] from Posts Answer join Posts Question on Question.Id = Answer.ParentId where Answer.PostTypeId = 2 group by Question.Id, Question.Title order by count(*) desc;