อนุมัติอัตราการแก้ไขของผู้ใช้ที่แนะนำ ไม่จำเป็นต้องใช้ตารางทั้งหมด
Approve Rate on Suggested User's Edits.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 CAST(COUNT(CASE WHEN NOT ApprovalDate IS NULL THEN 1 END) AS FLOAT) / COUNT(CASE WHEN NOT ApprovalDate IS NULL OR NOT RejectionDate IS NULL THEN 1 END) AS "Approval Rate", CAST(COUNT(CASE WHEN v.VoteTypeId = 2 THEN 1 END) AS FLOAT) / COUNT(DISTINCT v.Id) AS "Approval Vote Rate" FROM SuggestedEdits AS e LEFT JOIN SuggestedEditVotes AS v ON e.Id = v.SuggestedEditId WHERE e.OwnerUserId = @MyUserID