HW1

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 posttypeid, COUNT(*) as cnt  FROM posts  WHERE PostTypeId = 1 GROUP BY year(CreationDate), month(CreationDate), PostTypeId ORDER BY cnt DESC;

Enter Parameters

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