1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for people interested in the history and origins of science and mathematics

--Based on https://data.stackexchange.com/mathoverflow/revision/372216/479627/top-20-most-generous-users-bounties-awarded

SELECT
  TOP(##num?100##)
  Users.Id [User Link],
  Users.DisplayName,
  Users.Reputation,
  (SELECT SUM(BountyAmount) FROM Votes INNER JOIN Posts ON Votes.PostId=Posts.Id WHERE (Votes.UserId = Users.Id) AND (Votes.UserId<>Posts.OwnerUserId)) as TotalBountiesOthers,  
  (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 Users.Reputation > ##min?50##
ORDER BY
  TotalBountiesOthers DESC

fork query

edited jan 14 19

created jan 14 19 Martin20528