Top Investors

0

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.

Русский язык Meta

Q&A for лингвистов, этимологов, и энтузиастов русского языка

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 u.reputation > 10000
AND v.VoteTypeId = 8 -- BountyStart

GROUP BY u.Id

ORDER BY CAST(SUM(v.BountyAmount) AS float) DESC

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results