The top 50 users in the tweepy tag

0

Please login or register to vote for this query.

(click on this box to dismiss)

Emacs

Q&A for those using, extending or developing Emacs

--A query to see who the top users are in the tweepy tag.
with TopUsers as 
(
  select
    top 50
    Answers.OwnerUserId as UserId, 
    sum(Answers.Score) as Score,
    row_number() over (order by sum(Answers.Score) desc) as Position
  from Tags 
    JOIN PostTags on Tags.Id = PostTags.TagId
    JOIN Posts on Posts.Id = PostTags.PostId  
    JOIN Posts Answers on Answers.ParentId = Posts.Id 
  where 
    Tags.TagName = 'tweepy'
  group by Answers.OwnerUserId
  order by sum(Answers.Score) desc
)
select
  Position,
  UserId as [User Link],
  Score
from TopUsers
join Users on Users.Id = TopUsers.UserId
order by Position

Enter Parameters

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