Q&A about the site for mechanics and DIY enthusiast owners of cars, trucks, and motorcycles
SELECT cast (year(Posts.ClosedDate) as varchar(10)) as yr, month(Posts.ClosedDate) as m, count(CONCAT ('http://programmers.stackexchange.com/q/', Posts.Id)) as Questions FROM PostHistory JOIN Posts ON Posts.Id = PostHistory.PostId WHERE Posts.ClosedDate >= '2012-01-01' --AND Posts.ClosedDate < '2012-12-01' AND PostHistoryTypeId = 10 AND PostHistory.Comment != 1 group by year(Posts.ClosedDate), month(Posts.ClosedDate) ORDER BY 1 desc, 2 desc