How many questions per month does each tag in the top 10 tags get
Q&A about the site for practitioners, researchers, and students in cognitive science, psychology, neuroscience, and psychiatry
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 id from Tags where tagname LIKE 'delphi-%'
) as X
group by TagName, [Month]
order by TagName, [Month] asc