SELECT MIN(UserId) as [User Link], SUM(BountyAmount) as [...

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
    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('|', 25 * 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

Enter Parameters

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