Leaderboard of Bounty-Earners

2

Please login or register to vote for this query.

(click on this box to dismiss)

Quantum Computing

Q&A for engineers, scientists, programmers, and computing professionals interested in quantum computing

-- Created by aminography [https://stackoverflow.com/users/1631967/aminography]

SELECT TOP ##Top:int?100## 
    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 [Earned Bounty],
    Users.Reputation AS [Total Reputation]
    
FROM Users 
    INNER JOIN Posts ON Users.Id = Posts.OwnerUserId
    INNER JOIN Votes ON Votes.PostId = Posts.Id

WHERE Posts.PostTypeId = 2 AND            -- Answer
    Posts.CommunityOwnedDate IS NULL AND  -- Non-Community
    Votes.VoteTypeId = 9                  -- BountyClose

GROUP BY Users.Id, Users.Reputation

ORDER BY CASE Users.Id WHEN ##TargetUserId:int?0## THEN 1 ELSE 0 END DESC,
    [Earned Bounty] DESC

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results