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 professional and enthusiast programmers
SELECT TOP 10
Votes.UserId AS [User Link],
SUM(Votes.BountyAmount) AS [Bounty Total]
INNER JOIN Users ON Votes.UserId = Users.Id
Votes.VoteTypeId = 8 -- BountyStart
AND Votes.UserId > -1 -- Remove Community user