Top users per tag


Please login or register to vote for this query.

(click on this box to dismiss)


Q&A for for those using, extending or developing emacs

-- Top users per tag

declare @tag_id int = (select id from tags where tagname = ##Technology:string##);

--select rank() over (order by score desc) "Rank", * from (
  rank() over (order by sum(answers.score) desc) "Rank", "User Link"
  ,sum(answers.score) as "Score"
from users u
join posts answers on ( = answers.owneruserid)
join posts parent on (answers.parentid =
join posttags on ( = posttags.postid)
where posttags.tagid = @tag_id
and upper(u.location) like upper('%' + ##Location:string## + '%')
and answers.posttypeid = 2  -- answers only
group by
order by sum(answers.score) desc

Enter Parameters

Switch sites:
loading Hold tight while we fetch your results