ในแท็กแมชชีนเลิร์นนิง ไม่จำเป็นต้องใช้ตารางทั้งหมด
in the machine learning tag.It is not neccessary to use all the tables.
 ReviewTaskResults:  Id [ number]  ReviewTaskId [ number]  ReviewTaskResultTypeId [ number]  CreationDate [ time]  RejectionReasonId [ number]  Comment [ text] 
SELECT (SELECT COUNT(Id) FROM Posts LEFT JOIN PostTags ON PostTags.PostId = Id WHERE AnswerCount = 0 AND PostTags.TagId = 1002 AND ClosedDate IS NULL) AS notAnswered, (SELECT COUNT(Id) FROM Posts LEFT JOIN PostTags ON PostTags.PostId = Id WHERE AnswerCount > 0 AND PostTags.TagId = 1002 AND ClosedDate IS NULL) AS answered