Q&A about the site for engineers, producers, editors, and enthusiasts spanning the fields of video, and media creation
SELECT Month, COUNT(*) AS N FROM ( SELECT Id, DATEPART(yyyy, CreationDate) * 12 + DATEPART(mm, CreationDate) AS Month FROM PostsWithDeleted WHERE PostTypeId IN (1,2)) p GROUP BY Month ORDER BY Month