0

Please login or register to vote for this query.

(click on this box to dismiss)

Questions per month in a tag

Q&A for pro webmasters

-- Monthly tag popularity
-- Questions per month in a tag

select datepart(year,  p.CreationDate), datepart(month, p.CreationDate)m, count(*)
from Posts p
join PostTags pt on pt.PostId = p.Id
join Tags t on t.Id = pt.TagId 
where t.TagName = ##Tag:string##
group by datepart(month, p.CreationDate),
         datepart(year,  p.CreationDate)
         

fork query

created mar 4 11 Lennart Regebro