Q&A about the site for professional linguists and others with an interest in linguistic research and theory
-- 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 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 (SELECT SUM(BountyAmount) FROM Votes WHERE Votes.UserId = Users.Id) DESC