Effectiveness of Large Bounties

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for programmers

SELECT *, ROUND(Johnson.AverageScore / Johnson.BountyAmount, 2) AS ScorePerPoint
FROM (
SELECT BountyAmount, ROUND(AVG(CAST(Score as FLOAT)), 2) AS AverageScore, COUNT(*) AS NumPosts
    FROM Posts
    INNER JOIN Votes
    ON Posts.Id = Votes.PostId
    WHERE BountyAmount > 0
    AND Score < 100
    GROUP BY BountyAmount
    HAVING COUNT(*) >= 20
) AS Johnson
ORDER BY ScorePerPoint DESC

Enter Parameters

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