อันดับผู้ใช้และตัวแทนที่สะสมไว้ ไม่จำเป็นต้องใช้ตารางทั้งหมด
User Rank and Hoarded Rep.It is not neccessary to use all the tables.
 SuggestedEditVotes:  Id [ number]  SuggestedEditId [ number]  UserId [ number]  VoteTypeId [ number]  CreationDate [ time]  TargetUserId [ number]  TargetRepChange [ number] 
SELECT p.Id AS "user_link", p.Ranking, SUBSTRING(CAST(CAST(Ranking AS FLOAT) / Count * 100.00 AS TEXT), 1, 6) + '%' AS Percentile, Reputation, SUBSTRING(CAST(CAST(Reputation AS FLOAT) / Sum * 100.00 AS TEXT), 1, 6) + '%' AS "Hoarded rep" FROM (SELECT Id, ROW_NUMBER() OVER (ORDER BY Reputation DESC) AS Ranking, Reputation FROM Users WHERE Reputation > @MinRep) AS p, (SELECT Count = COUNT(*) FROM Users WHERE Reputation > @MinRep) AS Counts, (SELECT Sum = SUM(Reputation) FROM Users WHERE Reputation > @MinRep) AS Rep ORDER BY ranking LIMIT 1000