Q&A about the site for physical fitness professionals, athletes, trainers, and those providing health-related needs
--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) SELECT TOP(##num##) Users.Id [User Link], Users.DisplayName, Users.Reputation, (SELECT SUM(BountyAmount) FROM Votes WHERE Votes.UserId = Users.Id) as TotalBountiesAwarded, url = 'site://users/' + CAST(Users.Id AS varchar) + '?tab=bounties' 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 > ##min## ORDER BY TotalBountiesAwarded DESC