Top bounty-spenders

2

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT TOP 1000
    'site://users/' + CAST(u.Id AS nvarchar) + '/?tab=bounties&sort=offered|' + MAX(u.DisplayName) AS "User",
    SUM(BountyAmount) AS "BountySpend"
  FROM
    Votes AS v
    LEFT OUTER JOIN Users AS u
      ON v.UserId = u.Id
  WHERE
    VoteTypeId = 8 -- BountyStart
  GROUP BY
    u.Id
  ORDER BY
    "BountySpend" DESC

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results