Number of questions and answers by year

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 YEAR(p.CreationDate) as Year, COUNT(iif(PostTypeId=1, p.Id, null)) as Questions, COUNT(iif(PostTypeId=2, p.Id, null)) as Answers
FROM Posts p

WHERE PostTypeId in (1,2)

GROUP BY YEAR(p.CreationDate);

Enter Parameters

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