Q&A for scientists using computers to solve scientific problems
--Based on https://data.stackexchange.com/mathoverflow/revision/372216/479627/top-20-most-generous-users-bounties-awarded
--Adder url linking to list of bounties
-- Show top 20 most generous users: bounties awarded
-- Minimum of 50 reputation required (removes low rep users, Community and
-- sin-binned users)
Users.Id [User Link],
(SELECT SUM(BountyAmount) FROM Votes WHERE Votes.UserId = Users.Id) as TotalBountiesAwarded,
url = 'site://users/' + CAST(Users.Id AS varchar) + '?tab=bounties'
(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 > ##min##