instruction: R questions and answers per month (2). How many questions per month does each tag in the top 10 tags get
response: SELECT Month, COUNT(*) AS count FROM (SELECT Id, PostTypeId, DATEADD(MONTH, DATEDIFF(MONTH, 0, CreationDate), 0) AS "month" FROM Posts LEFT JOIN PostTags ON PostId = Id WHERE TagId = 4452) AS tmp GROUP BY Month, PostTypeId ORDER BY Month, PostTypeId