How many questions per month does each tag in the top 10 tags get
Q&A for users and developers of the Cardano cryptocurrency ecosystem
select *, count(*) from ( select CAST( cast(DATEPART(YYYY, CreationDate) as varchar) + '-' + cast(DATEPART(MM, CreationDate) as varchar) + '-01' as datetime) [Month], t.TagName 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 ) ) as X group by TagName, [Month] order by [Month] asc, TagName asc