ฉัน Unsung แค่ไหน? (+คำตัดสิน) จำนวนนับที่ยอมรับเป็นศูนย์และไม่เป็นศูนย์ คำตอบที่ยอมรับด้วยตนเองจะไม่นับรวม ระบุฮีโร่ที่ไม่ได้ร้องด้วยสายตาเช่นกัน ไม่จำเป็นต้องใช้ตารางทั้งหมด
How Unsung am I? (+verdict). Zero and non-zero accepted count.
Self-accepted answers do not count.
Identifies unsung heroes visually as well.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 *, CASE WHEN 'unscored_answers' > 10 AND 'percentage_unscored' >= 25 THEN 'Unsung Hero Indeed !!' ELSE 'Not just yet..' END AS "is_user_unsung_?" FROM (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 WHERE a.CommunityOwnedDate IS NULL AND a.OwnerUserId = '##UserId##' AND q.OwnerUserId != '##UserId##' AND a.PostTypeId = 2) AS UnsungInfo