ที่มีโค้ดรวมอยู่ด้วย..ไม่จำเป็นต้องใช้ทุกตาราง
s that include code..It is not neccessary to use all the tables.
 CloseAsOffTopicReasonTypes:  Id [ number]  IsUniversal [ boolean]  InputTitle [ text]  MarkdownInputGuidance [ text]  MarkdownPostOwnerGuidance [ text]  MarkdownPrivilegedUserGuidance [ text]  MarkdownConcensusDescription [ text]  CreationDate [ time]  CreationModeratorId [ number]  ApprovalDate [ time]  ApprovalModeratorId [ number]  DeactivationDate [ time]  DeactivationModeratorId [ number] 
SELECT CASE WHEN q.Body LIKE '%<code>%' THEN 'yes' ELSE 'no' END AS IncludesCode, COUNT(*) AS Count FROM Posts AS q WHERE q.PostTypeId = 1 AND q.ViewCount > 10 AND (q.Score < 0 OR NOT q.ClosedDate IS NULL) AND q.AnswerCount > 0 AND q.CreationDate > (SELECT MAX(CreationDate) FROM Posts) - 30 AND NOT EXISTS(SELECT 1 FROM Posts WHERE ParentId = q.Id AND PostTypeId = 2 AND (Score > 0 OR Id = q.AcceptedAnswerId)) GROUP BY CASE WHEN q.Body LIKE '%<code>%' THEN 'yes' ELSE 'no' END