Q&A about the site for linguists, teachers and students of the Ukrainian language
SELECT year(CreationDate) as Year, month(CreationDate) as Month, PostTypeId, COUNT(Id) as Count FROM Posts WHERE PostTypeId = 1 GROUP BY year(CreationDate), month(CreationDate), PostTypeId ORDER BY Year, Month, COUNT(Id) DESC