0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for Drupal developers and administrators

SELECT BountyAmount, AVG(Score) AS AverageScore, COUNT(*) AS NumPosts
FROM Posts
INNER JOIN Votes
ON Posts.Id = Votes.PostId
WHERE BountyAmount > 0
GROUP BY BountyAmount
ORDER BY BountyAmount

fork query

edited feb 6 12 anonymous

created feb 6 12 Matthew Read