SELECT YEAR(CreationDate) as year, MONTH(CreationDate) as...

0

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(CreationDate) as year, MONTH(CreationDate) as month, PostTypeId as post_type_id, COUNT(*) as cnt
FROM Posts
GROUP BY YEAR(CreationDate), MONTH(CreationDate), PostTypeId
ORDER BY YEAR(CreationDate), MONTH(CreationDate), PostTypeId

Enter Parameters

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