อัตราส่วนการโหวตเห็นด้วย/โหวตลงสำหรับผู้ใช้ที่เกินขีดจำกัดการทำซ้ำ ไม่จำเป็นต้องใช้ตารางทั้งหมด
Upvote/Downvote ratio for the users over a rep limit.It is not neccessary to use all the tables.
 Users:  Id [ number]  Reputation [ number]  CreationDate [ time]  DisplayName [ text]  LastAccessDate [ time]  WebsiteUrl [ text]  Location [ text]  AboutMe [ text]  Views [ number]  UpVotes [ number]  DownVotes [ number]  ProfileImageUrl [ text]  EmailHash [ text]  AccountId [ number] 
WITH Raw AS (SELECT Posts.OwnerUserId AS UserId, MIN(Users.Reputation) AS Reputation, COUNT(CASE WHEN Votes.VoteTypeId = 2 THEN 1 ELSE NULL END) AS UpVotes, COUNT(*) AS AllVotes FROM Users, Posts, Votes WHERE Users.Reputation >= '##MinRep:int?3000##' AND Votes.PostId = Posts.Id AND Posts.PostTypeId = 2 AND Posts.OwnerUserId = Users.Id AND Votes.VoteTypeId IN (2, 3) GROUP BY Posts.OwnerUserId) SELECT UserId AS "user_link", UserId, Reputation, UpVotes, AllVotes - UpVotes AS DownVotes, 100.0 * UpVotes / AllVotes AS UpVotePct FROM Raw ORDER BY UpVotePct DESC, UserId