Q&A for amateur radio enthusiasts
SELECT year(CreationDate) as Year, month(CreationDate) as Month, PostTypeId, COUNT(Id) as Count FROM Posts WHERE PostTypeId = 1 GROUP BY year(CreationDate), month(CreationDate), PostTypeId ORDER BY Year, Month, Count