0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

SELECT
  Input.BountySum,
  COUNT(1) Count_
FROM (
  SELECT
    v.UserId [User Link],
    SUM(v.BountyAmount) BountySum
  FROM Votes v
  WHERE v.VoteTypeId = 8 AND v.BountyAmount > 0
  GROUP BY v.UserId) AS Input
WHERE Input.BountySum < 100000
GROUP BY Input.BountySum
ORDER BY Input.BountySum

fork query

edited jan 31 22

created jan 31 22 LasseG