2

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for users of TeX, LaTeX, ConTeXt, and related typesetting systems

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

fork query

edited mar 9 15

created mar 9 15 senshin