Q&A about the site for those interested in the geology, meteorology, oceanography, and environmental sciences
-- Top Users by Number of Bounties Won SELECT Top 100 Posts.OwnerUserId As [User Link], COUNT(*) As BountiesWon FROM Votes INNER JOIN Posts ON Votes.PostId = Posts.Id WHERE VoteTypeId=9 GROUP BY Posts.OwnerUserId ORDER BY BountiesWon DESC