Finding fastest growing users for tag on stackoveflow

Howdy,

I got interested in how well do i stack up “against” other fellow SO users. Turns out - not too bad. I’m consistently top 3 over the last 3\2\1 years time frame :). Query:

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

ps. SO database schema.

Happy deploying!

Written on January 6, 2019