Q&A for teachers and students of the Esperanto language
SELECT YEAR(CreationDate) AS 'year', MONTH(CreationDate) AS 'month',PostTypeId, COUNT(Id) AS cnt FROM Posts GROUP BY YEAR(CreationDate), MONTH(CreationDate), PostTypeId ORDER BY cnt DESC;