เปอร์เซ็นต์สำหรับผู้ใช้ที่มีข้อมูลและผู้ใช้ที่ไม่ได้รับข้อมูล ไม่จำเป็นต้องใช้ตารางทั้งหมด
percentage for informed vs uninfomed users.It is not neccessary to use all the tables.
 ReviewRejectionReasons:  Id [ number]  Name [ text]  Description [ text]  PostTypeId [ number] 
SELECT 100.0 * SUM(CASE WHEN b.Id IS NULL AND NOT p.ClosedDate IS NULL THEN 1 ELSE 0 END) / SUM(CASE WHEN b.Id IS NULL THEN 1 ELSE 0 END) AS pClosedUninf, SUM(CASE WHEN NOT b.Id IS NULL AND NOT p.ClosedDate IS NULL THEN 1 ELSE 0 END) * 100.0 / SUM(CASE WHEN NOT b.Id IS NULL THEN 1 ELSE 0 END) AS pClosedInf FROM Posts AS p LEFT OUTER JOIN Badges AS b ON b.UserId = p.OwnerUserId AND b.Name = 'Informed' AND (b.Date < p.ClosedDate OR p.ClosedDate IS NULL)