User with highest amount of offered bounties on questions by others

1

Please login or register to vote for this query.

(click on this box to dismiss)

Computational Science

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

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 TotalBountiesAwarded,
  url = 'site://users/' + CAST(Users.Id AS varchar) + '?tab=bounties'
FROM Users
WHERE Users.Reputation > ##min?50##
ORDER BY
  TotalBountiesAwarded DESC

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results