ผู้ใช้ที่ downvote แต่ไม่โพสต์ ไม่จำเป็นต้องใช้ตารางทั้งหมด
Users who downvote but don't post.It is not neccessary to use all the tables.
 SuggestedEdits:  Id [ number]  PostId [ number]  CreationDate [ time]  ApprovalDate [ time]  RejectionDate [ time]  OwnerUserId [ number]  Comment [ text]  Text [ text]  Title [ text]  Tags [ text]  RevisionGUID [ other] 
SELECT Users.DisplayName, COUNT(Posts.Id) AS Posts, Users.DownVotes, Users.DownVotes / CAST(s.Total AS FLOAT) AS "% of All Downvotes", Users.DownVotes / CAST(COUNT(Posts.Id) AS FLOAT) AS "Downvotes/Posts", Users.DownVotes / CAST(Users.UpVotes AS FLOAT) AS "Downvotes/upvotes" FROM Users JOIN Posts ON Users.Id = Posts.OwnerUserId CROSS JOIN (SELECT SUM(DownVotes) AS Total FROM Users WHERE Users.Id != -1) AS s WHERE Users.Id != -1 AND Users.DownVotes > 15 AND Users.UpVotes > 0 AND Posts.CreationDate > CAST('1/1/2013' AS DATETIME) GROUP BY Users.DisplayName, DownVotes, UpVotes, s.Total ORDER BY Users.DownVotes / CAST(COUNT(Posts.Id) AS FLOAT) DESC