CreationDate ของ - โดยไม่รวมบางแท็ก ไม่จำเป็นต้องใช้ตารางทั้งหมด
's CreationDate - with some tags excluded.It is not neccessary to use all the tables.
 TagSynonyms:  Id [ number]  SourceTagName [ text]  TargetTagName [ text]  CreationDate [ time]  OwnerUserId [ number]  AutoRenameCount [ number]  LastAutoRename [ time]  Score [ number]  ApprovedByUserId [ number]  ApprovalDate [ time] 
WITH acounts_cte AS (SELECT LAST_DATE_OF_MONTH(a.CreationDate) AS Cmonth, COUNT(DISTINCT a.Id) AS Acount FROM Posts AS q INNER JOIN Posts AS a ON a.ParentId = q.Id WHERE NOT ((q.Tags LIKE '%<##tag1?big-list##>%') OR (q.Tags LIKE '%<##tag2?soft-question##>%')) GROUP BY LAST_DATE_OF_MONTH(a.CreationDate)), qcounts_cte AS (SELECT LAST_DATE_OF_MONTH(q.CreationDate) AS Cmonth, COUNT(DISTINCT q.Id) AS QCount FROM Posts AS q WHERE NOT ((q.Tags LIKE '%<##tag1>%') OR (q.Tags LIKE '%<##tag2##>%')) GROUP BY LAST_DATE_OF_MONTH(q.CreationDate)) SELECT q.Cmonth AS CMonth, CAST(q.QCount + a.ACount AS INT) AS "total_posts", q.Qcount AS "total_questions", a.Acount AS "total_answers" FROM acounts_cte AS a INNER JOIN qcounts_cte AS q ON a.Cmonth = q.Cmonth ORDER BY q.Cmonth