0

Please login or register to vote for this query.

(click on this box to dismiss)

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

SELECT Aggregate.UserId AS [User Link],
       Aggregate.*
  FROM (SELECT Selection.UserId,
               CAST(Selection.TotalBounty AS FLOAT) AS 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
         WHERE Users.Location = 'Pensacola, FL') Aggregate
 ORDER BY Aggregate.TotalBounty / Aggregate.TotalReputation DESC,
          Aggregate.TotalReputation ASC;

view current version

edited may 22 19

created may 22 19 jon.doe17775