ดูตามชื่อเสียงของผู้ใช้ ไม่จำเป็นต้องใช้ตารางทั้งหมด
views by user reputation.It is not neccessary to use all the tables.
 Comments:  Id [ number]  PostId [ number]  Score [ number]  Text [ text]  CreationDate [ time]  UserDisplayName [ text]  UserId [ number]  ContentLicense [ text] 
WITH ViewTotals AS (SELECT u.Reputation, SUM(CAST(p.ViewCount AS INT)) AS ViewCount FROM Posts AS p INNER JOIN Users AS u ON p.OwnerUserId = u.Id WHERE p.PostTypeId = 1 GROUP BY u.Reputation) SELECT v1.Reputation * 100.0 / @MaxReputation, SUM(v2.ViewCount) * 100.0 / @TotalViews FROM ViewTotals AS v1 INNER JOIN ViewTotals AS v2 ON v1.Reputation >= v2.Reputation GROUP BY v1.Reputation ORDER BY v1.Reputation