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 about the site for practitioners, researchers, and students in cognitive science, psychology, neuroscience, and psychiatry
MIN(UserId) as [User Link],
SUM(BountyAmount) as [Bounty Spending],
MIN(u.Reputation) as Reputation,
CAST(SUM(BountyAmount) AS float) / (MIN(u.Reputation) + SUM(BountyAmount)) as [Portion of Rep Spent],
REPLICATE('|', 50 * CAST(SUM(BountyAmount) AS float) / (MIN(u.Reputation) + SUM(BountyAmount))) as [||||||||||||||||||||||||||||||||||||||||||||||||||]
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