c)

0

Please login or register to vote for this query.

(click on this box to dismiss)

Webmasters

Q&A for pro webmasters

with Post_Tags as ( select t.Id, t.TagName as 'Tagname', pt.PostId as 'PostId'
from PostTags pt
left join Tags t on pt.TagId = t.Id)
select top 10 rank() over(order by count(pt.Id) desc) as 'Rank',count(pt.Id) as 'count', pt.Tagname, year(p.CreationDate) as 'year'
from Posts p
left join Post_Tags pt on p.Id = pt.PostId
where year(p.CreationDate)=2020
group by pt.Tagname, year(p.CreationDate)
order by Rank

Enter Parameters

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