Bounty to Reputation Comparison

0

Please login or register to vote for this query.

(click on this box to dismiss)

Audio-Video Production Meta

Q&A about the site for engineers, producers, editors, and enthusiasts spanning the fields of video, and media creation

/*SELECT *
  FROM Users
 WHERE Id = 216356;*/

SELECT Selection.UserId,
       Selection.TotalBounty,
       Users.Reputation,
       Selection.TotalBounty + Users.Reputation AS TotalReputation
  FROM (SELECT UserId,
               sum(BountyAmount) AS TotalBounty
          FROM Votes
         WHERE VoteTypeId = (SELECT Id
                               FROM VoteTypes
                              WHERE Name = 'BountyStart')
           AND BountyAmount != 0
         GROUP BY UserId) selection
  JOIN Users
    ON Users.Id = selection.UserId
 ORDER BY Selection.TotalBounty DESC;
           

SELECT *
  FROM VoteTypes;

Enter Parameters

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