แท็ก Facebook และคำถามที่ยังไม่ได้ตอบ ไม่จำเป็นต้องใช้ตารางทั้งหมด
Facebook Tags and Unanswered Questions.It is not neccessary to use all the tables.
 ReviewTaskStates:  Id [ number]  Name [ text]  Description [ text] 
SELECT SUM(CASE WHEN AnswerCount = 0 THEN 1 ELSE 0 END) AS Unanswered, SUM(CASE WHEN AcceptedAnswerId IS NULL THEN 1 ELSE 0 END) AS NoAcceptedAnswer, COUNT(*) AS Total FROM Posts WHERE Tags LIKE '%facebook%' AND ClosedDate IS NULL GROUP BY DATEADD(dd, 0, DATEDIFF(dd, 0, CreationDate))