Top 1000 Bounty Earner Users of a Specific Tag on StackOverflow


Please login or register to vote for this query.

(click on this box to dismiss)

Interpersonal Skills

Q&A for people looking to improve their interpersonal communication skills

-- Created by aminography []

    ROW_NUMBER() OVER(ORDER BY SUM(Votes.BountyAmount) DESC) AS [Rank],
    Users.Id AS [User Link],
    Count(Votes.Id) AS [Bounty Count],
    SUM(Votes.BountyAmount) AS [##Tag?android## Earned Bounty],
    Users.Reputation AS [Total Reputation]
FROM Users 
    INNER JOIN Posts ON Users.Id = Posts.OwnerUserId
    INNER JOIN PostTags ON PostTags.PostId = Posts.ParentId
    INNER JOIN Votes ON Votes.PostId = Posts.Id
    INNER JOIN Tags ON Tags.Id = PostTags.TagId

WHERE Posts.PostTypeId = 2 AND            -- Answer
    Posts.CommunityOwnedDate IS NULL AND  -- Non-Community
    Votes.VoteTypeId = 9   AND            -- BountyClose
    Tags.TagName = '##Tag##'              -- Tag Name

GROUP BY Users.Id, Users.Reputation

ORDER BY [##Tag## Earned Bounty] DESC

Enter Parameters

Switch sites:
loading Hold tight while we fetch your results