How many questions per month does each tag in the top 10 tags get
Q&A for Muslims, experts in Islam, and those interested in learning more about Islam
select *, count([Month]) as count, AnswerCount from ( select CAST( cast(DATEPART(YYYY, CreationDate) as varchar) + '-' + cast(DATEPART(MM, CreationDate) as varchar) + '-01' as datetime) [Month], t.TagName, p.AnswerCount from Posts p join PostTags pt on pt.PostId = p.Id join Tags t on t.Id = pt.TagId where TagId in ( select Id from Tags t where t.TagName = '##TagName##' ) ) as X group by TagName, [Month], AnswerCount order by [Month] asc, TagName asc