How many questions per month does each tag in the top 10 tags get
Q&A for scientists using computers to solve scientific problems
select *, count(*) from
cast(DATEPART(YYYY, CreationDate) as varchar) + '-' + cast(DATEPART(MM, CreationDate) as varchar) + '-01'
as datetime) [Month],
from Posts p
join PostTags pt on pt.PostId = p.Id
join Tags t on t.Id = pt.TagId
where TagId in
select top 10 Id from Tags
order by Count desc
and CreationDate > '2019-12-31'
) as X
group by TagName, [Month]
order by [Month] asc, TagName asc