count by tag by month

0

Please login or register to vote for this query.

(click on this box to dismiss)

Music Fans

Q&A for music historians, critics, and fans

select tagname, count(*) as c,convert(varchar(10),year(p.creationdate)) + '-'+ convert(varchar(10),month(p.creationdate)) as yearmonth

from posts p
join posttags pt on pt.postid=p.id
join tags t on pt.tagid=t.id

where year(p.creationdate) >= 2016


group by tagname, convert(varchar(10),year(p.creationdate)) + '-'+ convert(varchar(10),month(p.creationdate))
having count(*) > 20
order by tagname, convert(varchar(10),year(p.creationdate)) + '-'+ convert(varchar(10),month(p.creationdate))

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results