SELECT u.Id as [User Link], SUM(v.BountyAmount) as [Bount...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Materials Modeling Meta

Q&A for materials modelers and data scientists

SELECT
    u.Id 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 IN (8,9)
AND v.BountyAmount > 0
GROUP BY u.Id
ORDER BY SUM(BountyAmount) DESC

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results