Users by total bounty given

0

Please login or register to vote for this query.

(click on this box to dismiss)

Returns, for each user, the total amount of reputation offered as bounty, the number of bounties offered, and current reputation, ordered by the total reputation offered.

Science Fiction and Fantasy Meta

Q&A about the site for science fiction and fantasy enthusiasts

SELECT TOP 100
RANK() OVER (ORDER BY SUM(Votes.BountyAmount) DESC) AS Rank,
  SUM(Votes.BountyAmount) AS BountyTotal
FROM
  Votes
  INNER JOIN Users ON Votes.UserId = Users.Id
  LEFT JOIN Posts questions ON Votes.PostId = questions.Id
WHERE
  Votes.VoteTypeId = 8 --BountyStart
  AND Votes.UserId > -1 --Remove Community user
  AND Users.Reputation > ##MinReputation?1##
GROUP BY
  Votes.UserId,
  Users.Id
HAVING 
  COUNT(Votes.BountyAmount) >= ##MinBountyNo?1##
ORDER BY
  SUM(Votes.BountyAmount) DESC

Enter Parameters

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