1

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 professional and enthusiast programmers

DECLARE @UserId int = ##UserId##
DECLARE @MinTotRep int = ##MinTotRep##

SELECT
  MIN(v.UserId) as [User Link],
  SUM(v.BountyAmount) as [Bounty Spending],
  MIN(u.Reputation) as [Reputation],
  SUM(v.BountyAmount) + MIN(u.Reputation) as [Total Rep],
  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
GROUP BY u.Id

HAVING MIN(u.Reputation) + SUM(v.BountyAmount) > @MinTotRep OR u.Id=@UserId


ORDER BY CAST(SUM(v.BountyAmount) AS float) / (MIN(u.Reputation) + SUM(v.BountyAmount)) DESC

fork query

edited feb 15 14 tohecz

created apr 2 12 Jeremy Banks