instruction: Top users by offered bounties in 2017.
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, Users.DisplayName, Users.Reputation, SUM(Votes.BountyAmount) AS BountyOfferedTotal, COUNT(*) AS BountyOfferedCount 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 = 8 AND Posts.PostTypeId = 1 AND Votes.CreationDate BETWEEN '01/01/2017' AND '12/31/2017' GROUP BY Users.Id, Users.DisplayName, Users.Reputation ORDER BY BountyOfferedTotal DESC, Users.Id LIMIT 100