7

Please login or register to vote for this query.

(click on this box to dismiss)

Investor users ranked by total bounty spending on bounties. This may vary from the value listed in users' profiles because this includes (all?) bounties on deleted posts, which are not included in profiles.

Q&A for apps, scripts, and development with the Stack Exchange API

SELECT
    AVG(UserId) as [User Link],
    SUM(BountyAmount) as [Bounty Spending],
    STR(CAST(SUM(BountyAmount) AS float) / AVG(u.Reputation), 8, 2) as [Bounty Spending:Reputation ratio]
FROM Users u
INNER JOIN Votes v ON v.UserId = u.Id
WHERE u.Id > 0
AND v.VoteTypeId = 8 -- BountyStart
GROUP BY u.Id
ORDER BY SUM(BountyAmount) DESC

view current version

edited apr 2 12

created apr 2 12 Jeremy Banks