Questions with the greatest number of answers

0

Please login or register to vote for this query.

(click on this box to dismiss)

Role-playing Games

Q&A for gamemasters and players of tabletop, paper-and-pencil role-playing games

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;

Enter Parameters

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