0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for researchers, developers, and users of Tor

SELECT FORMAT(CreationDate, 'yyyy') year, 
      FORMAT(CreationDate, 'MM') month, 
      PostTypeId,
      COUNT(*) cnt
FROM Posts
GROUP BY FORMAT(CreationDate, 'yyyy'), FORMAT(CreationDate, 'MM'), PostTypeId
HAVING PostTypeId = 1
ORDER BY cnt DESC;

fork query

edited sep 19

created sep 19 anonymous