Q&A for professional and enthusiast programmers
select row_number() over (order by sum(v.BountyAmount) desc, u.Id) ,u.Id as [User Link] ,u.Reputation ,count(v.Id) as Bounties ,avg(v.BountyAmount) as [Average Spent] ,sum(v.BountyAmount) as [Total Spent] ,[Percent of Rep Spent] = format(1.0 * sum(v.BountyAmount) / nullif(sum(v.BountyAmount) + u.Reputation, 0.0), 'p3') from Users as u join Votes as v on v.UserId = u.Id and v.VoteTypeId = 8 -- bountystart where u.Id > 0 group by u.Id ,u.Reputation order by [Total Spent] desc ,u.Id offset ##OffsetRows:int?0## rows fetch next ##ReturnRows:int?10## rows only; -- OffsetRows: Number of rows to skip -- ReturnRows: Number of rows to return