Q&A about the site for scientific skepticism
-- Show top 20 most generous users: bounties awarded -- 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, (SELECT SUM(BountyAmount) FROM Votes WHERE Votes.UserId = Users.Id)*100/Users.Reputation as BountyPercentage 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 TotalBountiesAwarded DESC