We owe them reputation
Q&A about the site for mechanics and DIY enthusiast owners of cars, trucks, and motorcycles
-- Top 100 voters -- We owe them reputation SELECT TOP 100 U.Id AS [User Link], U.Reputation, (U.UpVotes * 10 - U.DownVotes * 2) AS ReputationGiven, U.Reputation - (U.UpVotes * 10 - U.DownVotes * 2) as ReputationDifference, (100 * (U.UpVotes * 10 - U.DownVotes * 2) ) / U.Reputation as Ratio FROM Users U WHERE u.reputation > 1000 and u.id != -1 -- Community ORDER BY Ratio ASC, ReputationGiven aSC