Number of questions and answers by year

1

Please login or register to vote for this query.

(click on this box to dismiss)

Cognitive Sciences Meta

Q&A about the site for practitioners, researchers, and students in cognitive science, psychology, neuroscience, and psychiatry

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)
ORDER BY YEAR(p.CreationDate)

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results