0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for active researchers, academics and students of physics

select top 30 u.id as [User Link],  
       u.WebsiteUrl,
       t.TagName,
       sum(score) totscore
from Posts p, PostTags pt, Tags t, Users u
where p.CreationDate > DATEADD(year,##years:int?-3##,GETDATE())
AND PostTypeId = 2 -- answer
AND p.ParentId = pt.PostId
AND pt.TagId = t.id
AND p.OwnerUserId = u.id
AND t.TagName = ##tag:string?azure##
group by u.id, 
         u.WebsiteUrl,
         t.TagName
order by totscore desc

fork query

edited jan 28 22

created jan 28 22 anonymous