Q&A for community managers, administrators, and moderators
-- Top Users by Number of Bounties Won SELECT Top 100 Posts.OwnerUserId As [User Link], COUNT(*) As BountiesWon, Users.Reputation FROM Votes INNER JOIN Users ON Votes.PostId = Users.Id INNER JOIN Posts ON Votes.PostId = Posts.Id WHERE VoteTypeId=9 GROUP BY Posts.OwnerUserId, Users.Reputation ORDER BY BountiesWon DESC