1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for music historians, critics, and fans

select year(p.creationdate) [year]
     , count(p.id) as [count]
from postswithdeleted p
where (p.PostTypeId=1) and (p.Tags Like '%<##tagName?big-list##>%')
group by year(p.creationdate)
order by year(p.creationdate)

fork query

created oct 30 22 Martin20528