Bounty to Reputation Comparison

0

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 *
  FROM Users
 WHERE Id = 216356;*/

SELECT UserId,
       TotalBounty
  FROM (SELECT UserId,
               sum(BountyAmount) AS TotalBounty
          FROM Votes
         WHERE VoteTypeId = (SELECT Id
                               FROM VoteTypes
                              WHERE Name = 'BountyStart')
           AND BountyAmount != 0
         GROUP BY UserId) query
 ORDER BY TotalBounty DESC;
           

SELECT *
  FROM VoteTypes;

Enter Parameters

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