Bounty to Reputation Comparison


Please login or register to vote for this query.

(click on this box to dismiss)

Android Enthusiasts

Q&A for enthusiasts and power users of the Android operating system

  FROM Users
 WHERE Id = 216356;*/

SELECT Aggregate.*,
       Aggregate.TotalBounty / CAST(Aggregate.TotalReputation AS FLOAT)
  FROM (SELECT Selection.UserId,
               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) Aggregate
 ORDER BY Aggregate.TotalBounty / Aggregate.TotalReputation DESC;

Enter Parameters

Switch sites:
loading Hold tight while we fetch your results