0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for information security professionals

select year(p.CreationDate), sum(p.ViewCount) from Posts p inner join PostTags pt on p.Id=pt.PostId inner join Tags t on pt.TagId=t.Id where p.PostTypeId=1 and t.TagName=##Tag:string## group by year(p.CreationDate) order by year(p.CreationDate)

fork query

edited nov 20 23

created nov 20 23 Cristik