3

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.

Q&A for ebook publishers and readers

SELECT TOP 10
  Votes.UserId AS [User Link],
  SUM(Votes.BountyAmount) AS [Bounty Total]
FROM
  Votes
  INNER JOIN Users ON Votes.UserId = Users.Id
WHERE
  Votes.VoteTypeId = 8  -- BountyStart
  AND Votes.UserId > -1 -- Remove Community user
GROUP BY
  Votes.UserId
ORDER BY
  SUM(Votes.BountyAmount) DESC

fork query

edited mar 7 22 KyleMit

created aug 6 15 E.P.