s ตามเดือน SO-PT ไม่จำเป็นต้องใช้ตารางทั้งหมด
s by month SO-PT.It is not neccessary to use all the tables.
 PostFeedback:  Id [ number]  PostId [ number]  IsAnonymous [ boolean]  VoteTypeId [ number]  CreationDate [ time] 
WITH t1 AS (SELECT TIME_TO_STR(p.CreationDate, '%Y') AS Year, TIME_TO_STR(p.CreationDate, '%m') AS Month, COUNT(*) AS totalQuestions, COUNT(AcceptedAnswerId) AS AcceptedAnswers FROM Posts AS p WHERE Tags LIKE '%pandas%' GROUP BY TIME_TO_STR(p.CreationDate, '%Y'), TIME_TO_STR(p.CreationDate, '%m')) SELECT DATE(CONCAT(Year, '-', Month, '-01')), totalQuestions, AcceptedAnswers FROM t1 ORDER BY 1