Most Bountiful Users


Please login or register to vote for this query.

(click on this box to dismiss)

Sums up the bounty amounts users have given. Also ranks them based on their total bounty amounts and gives a percentage of total bounty over their current rep as well as total bounty over their supposed rep if they weren't rep-capped.

Amateur Radio

Q&A for amateur radio enthusiasts

  RANK() OVER(ORDER BY SUM(Votes.BountyAmount) DESC) AS Rank,
  Users.Id AS [User Link],
  Users.Reputation AS [Current Rep],
  SUM(Votes.BountyAmount) AS [Bounty Amount],
  COUNT(Votes.BountyAmount) AS [Number of Bounties],
  '~' + CAST(CAST(CAST(SUM(Votes.BountyAmount) AS Decimal) / CAST(Users.Reputation AS Decimal) * 100.00 AS Decimal) AS varchar(MAX)) + '%' AS [Percentage of Rep]
FROM Votes
    ON Votes.UserId = Users.Id
WHERE Votes.BountyAmount IS NOT NULL
  AND Users.Id <> -1 -- Exclude the 'Community' user 
GROUP BY Users.Id,
ORDER BY SUM(Votes.BountyAmount) DESC;

Enter Parameters

Switch sites:
loading Hold tight while we fetch your results