Top 20 most generous users (bounties awarded vs total reputation)

1

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

-- Show top 20 most generous users: bounties awarded vs total reputation
-- Minimum of 50 reputation required (removes low rep users, Community and
-- sin-binned users)

SELECT
  TOP(20)
  Users.Id [User Link],
  Users.DisplayName,
  Users.Reputation,
  (SELECT SUM(BountyAmount) FROM Votes WHERE Votes.UserId = Users.Id) as TotalBountiesAwarded,
  Users.Reputation / ((SELECT SUM(BountyAmount) FROM Votes WHERE Votes.UserId = Users.Id) * 1.0) as Ratio
FROM Users
WHERE
  (SELECT SUM(BountyAmount) FROM Votes WHERE Votes.UserId = Users.Id) > 0 -- ensure a bounty has been awarded
  -- exclude Community and sin binned users
  -- minimum amount here to qualify for this?
  AND Users.Reputation > 50 
ORDER BY 
  Users.Reputation / ((SELECT SUM(BountyAmount) FROM Votes WHERE Votes.UserId = Users.Id) * 1.0) ASC

Enter Parameters

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