Top Bounty Hunters

1

Please login or register to vote for this query.

(click on this box to dismiss)

Physics

Q&A for active researchers, academics and students of physics

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

Enter Parameters

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