Q&A for historians and history buffs
SELECT [year-month], a.PostTypeId, COUNT(a.Id) AS cnt FROM ( SELECT Id, PostTypeId, CONVERT(CHAR(4), CreationDate, 120) + CONVERT(CHAR(4), CreationDate, 100) AS [year-month] FROM Posts ) as a GROUP BY [year-month], PostTypeId ORDER BY cnt desc, PostTypeId;