instruction: Questions and answers per month for a specific tag ID. How many questions per month does each tag in the top 10 tags get
response: SELECT Month, PostTypeId, COUNT(*) AS count FROM (SELECT Id, PostTypeId, DATEADD(MONTH, DATEDIFF(MONTH, 0, CreationDate), 0) AS "month" FROM Posts) AS tmp GROUP BY PostTypeId, Month ORDER BY PostTypeId, Month