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 meta-discussion of the Stack Exchange family of Q&A websites
SELECT MIN(v.UserId) as [User Link], SUM(v.BountyAmount) as [Bounty Spending], MIN(u.Reputation) as Reputation, CAST(SUM(v.BountyAmount) AS float) / (MIN(u.Reputation) + SUM(v.BountyAmount)) as [Fraction of Rep Spent], REPLICATE('|', 50 * CAST(SUM(v.BountyAmount) AS float) / (MIN(u.Reputation) + SUM(v.BountyAmount))) as [||||||||||||||||||||||||||||||||||||||||||||||||||] FROM Users u INNER JOIN Votes v ON v.UserId = u.Id WHERE u.Id > 0 AND v.VoteTypeId = 8 -- BountyStart -- Check for a corresponding BountyEnd event -- (this probably stil inaccurate, but should be an improvement) AND 0 < ( SELECT COUNT(w.PostId) FROM Votes w WHERE w.VoteTypeId = 9 -- BountyEnd AND w.PostId = v.PostId ) GROUP BY u.Id ORDER BY SUM(BountyAmount) DESC