ป้าย 'แจ้งแล้ว' ส่งผลต่อคะแนนการโพสต์หรือไม่ ไม่จำเป็นต้องใช้ตารางทั้งหมด
Does the 'Informed' badge affect post score?.It is not neccessary to use all the tables.
 PostFeedback:  Id [ number]  PostId [ number]  IsAnonymous [ boolean]  VoteTypeId [ number]  CreationDate [ time] 
SELECT p.Score AS "Score", SUM(CASE WHEN b.Id IS NULL THEN 1 ELSE 0 END) AS "Not Informed", SUM(CASE WHEN b.Id IS NULL THEN 0 ELSE 1 END) AS "Informed" FROM Posts AS p LEFT OUTER JOIN Badges AS b ON b.UserId = p.OwnerUserId AND b.Name = 'Informed' WHERE p.PostTypeId = 2 GROUP BY p.Score ORDER BY p.Score