instruction: Top 100 users ordered by earned bounties.
response: SELECT ROW_NUMBER() OVER (ORDER BY SUM(Votes.BountyAmount) DESC, Users.Id) AS rnSum, ROW_NUMBER() OVER (ORDER BY COUNT(*) DESC, Users.Id) AS rnCount, Users.Id AS "user_link", Users.Reputation, SUM(Votes.BountyAmount) AS BountyEarnedTotal, COUNT(*) AS BountyEarnedCount FROM Votes INNER JOIN Posts ON Posts.Id = Votes.PostId INNER JOIN Users ON Users.Id = Posts.OwnerUserId WHERE NOT Votes.BountyAmount IS NULL AND Votes.VoteTypeId = 9 AND Posts.PostTypeId = 2 GROUP BY Users.Id, Users.DisplayName, Users.Reputation ORDER BY BountyEarnedTotal DESC, Users.Id LIMIT 100