อัตราส่วน QA สำหรับผู้ใช้ล่าสุด ไม่จำเป็นต้องใช้ตารางทั้งหมด
QA ratio for recent users.It is not neccessary to use all the tables.
 ReviewTaskStates:  Id [ number]  Name [ text]  Description [ text] 
SELECT Id AS "user_link", LastAccessDate, CASE ANSWERS WHEN 0 THEN 'infinity' ELSE CAST(ROUND(QUESTIONS / CAST(ANSWERS AS FLOAT), 2) AS TEXT) END AS "Q:A ratio" FROM (SELECT u.Id, u.LastAccessDate, SUM(CASE p.PostTypeId WHEN 1 THEN 1 ELSE 0 END) AS "Questions", SUM(CASE p.PostTypeId WHEN 2 THEN 1 ELSE 0 END) AS "Answers" FROM Users AS u INNER JOIN Posts AS p ON u.Id = p.OwnerUserId GROUP BY u.Id, u.LastAccessDate ORDER BY u.LastAccessDate DESC LIMIT 100) AS temp