Q&A about the site for road warriors and seasoned travelers
-- Top users per tag declare @limit int = 100; declare @tag_name nvarchar(35) = '##TagName##'; declare @tag_id int = (select id from tags where tagname = @tag_name); select top (@limit) rank() over (order by sum(answers.score) desc) "Rank", users.id "User Link" ,sum(answers.score) as "Score" from users join posts answers on (users.id = answers.owneruserid) join posts parent on (answers.parentid = parent.id) join posttags on (parent.id = posttags.postid) where posttags.tagid = @tag_id and answers.posttypeid = 2 -- answers only and answers.CreationDate >= '2019-10-07' group by users.id order by sum(answers.score) desc ; select id from tags where tagname = @tag_name;