1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for people interested in the history and origins of science and mathematics

SELECT Top 50
  Posts.OwnerUserId as [User Link],
  COUNT(*) as [Bounties Won],
  SUM(Votes.BountyAmount) as [Bounty Amount],
  Users.Reputation as [Reputation],
  ROUND(1.00 * SUM(Votes.BountyAmount) / Users.Reputation * 100, 0) as [Percentage]
FROM Votes
  INNER JOIN Posts ON Votes.PostId = Posts.Id
  INNER JOIN Users ON Posts.OwnerUserId = Users.Id
WHERE
  VoteTypeId=9 AND Posts.OwnerUserId IS NOT NULL AND Users.Reputation > 1
GROUP BY
  Posts.OwnerUserId, Users.Reputation
ORDER BY
  [Bounties Won] DESC

fork query

edited dec 15 18

created dec 15 18 Aperçu