0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for music historians, critics, and fans

SELECT TOP 5 
    YEAR(CreationDate) AS year, 
    DATENAME(MONTH, CreationDate) AS month,
    PostTypeId, 
    COUNT(*) AS cnt
FROM Posts
WHERE PostTypeId=1
GROUP BY YEAR(CreationDate),DATENAME(MONTH, CreationDate), PostTypeId
ORDER BY cnt DESC;

fork query

edited sep 17

created sep 17 anonymous