Q&A for people organizing, marketing or licensing open source development projects
SELECT year(Posts.ClosedDate) 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