คะแนนเฉลี่ยสำหรับคำถามปิด ไม่จำเป็นต้องใช้ตารางทั้งหมด
Average Scores for Closed Questions.It is not neccessary to use all the tables.
 PostNotices:  Id [ number]  PostId [ number]  PostNoticeTypeId [ number]  CreationDate [ time]  DeletionDate [ time]  ExpiryDate [ time]  Body [ text]  OwnerUserId [ number]  DeletionUserId [ number] 
SELECT TIME_TO_STR(CreationDate, '%Y') * 12 + TIME_TO_STR(CreationDate, '%m'), AVG(Score) FROM Posts GROUP BY TIME_TO_STR(CreationDate, '%Y') * 12 + TIME_TO_STR(CreationDate, '%m') HAVING TIME_TO_STR(CreationDate, '%Y') * 12 + TIME_TO_STR(CreationDate, '%m') > 24105 ORDER BY TIME_TO_STR(CreationDate, '%Y') * 12 + TIME_TO_STR(CreationDate, '%m')