ฉัน Unsung แค่ไหน? (ค้นหาตามชื่อที่แสดง) ไม่จำเป็นต้องใช้ตารางทั้งหมด
How Unsung am I? (Search by Display Name).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 COUNT(a.Id) AS "accepted_answers", SUM(CASE WHEN a.Score = 0 THEN 0 ELSE 1 END) AS "scored_answers", SUM(CASE WHEN a.Score = 0 THEN 1 ELSE 0 END) AS "unscored_answers", SUM(CASE WHEN a.Score = 0 THEN 1 ELSE 0 END) * 1000 / COUNT(a.Id) / 10.0 AS "percentage_unscored" FROM Posts AS q INNER JOIN Posts AS a ON a.Id = q.AcceptedAnswerId INNER JOIN Users AS u ON u.Id = a.OwnerUserId WHERE a.CommunityOwnedDate IS NULL AND a.OwnerUserId = u.Id AND q.OwnerUserId != u.Id AND a.PostTypeId = 2 AND u.DisplayName = '##DisplayName##'