0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for anime and manga fans

select DATEPART(year, q.CreationDate) Year, TagName, count(*)
from PostTags pt
join Posts q on q.Id=pt.PostId
join Tags t on t.Id=pt.TagId
where 
TagName in ('reactjs','angular', 'angularjs','vue.js','svelte','preact','ember.js','solid-js','alpine.js','lit-element','qwik','polymer','backbone','stenciljs','htmx','aurelia','stimulusjs','astrojs','knockout.js','jquery','mithril','cyclejs','next.js','remix.run','meteor','roit.js','nuxt.js','infernojs','hyperapp')
and q.CreationDate < dateadd(month, datediff(month, 0, getdate()), 0)
group by DATEPART(year, q.CreationDate), TagName
order by DATEPART(year, q.CreationDate)

fork query

edited may 2

created may 2 Kitson