Most generous users since custom date (bounties awarded)

1

Please login or register to vote for this query.

(click on this box to dismiss)

List of all users who awarded bounties since date, sorted by total amount of bounties.

Stack Overflow

Q&A for professional and enthusiast programmers

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

SELECT
  Users.Id [User Link],
  Users.DisplayName,
  Users.Reputation,
  (SELECT SUM(BountyAmount) FROM Votes WHERE Votes.UserId = Users.Id AND Votes.CreationDate > '##Year##') as TotalBountiesAwarded
FROM Users
WHERE
  (SELECT SUM(BountyAmount) FROM Votes WHERE Votes.UserId = Users.Id AND Votes.CreationDate > '##Year##') > 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 (SELECT SUM(BountyAmount) FROM Votes WHERE Votes.UserId = Users.Id AND Votes.CreationDate > '##Year##') DESC

Enter Parameters

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