ต่อวันในปี 2554 ไม่จำเป็นต้องใช้ทุกตาราง
s per day in 2011It is not neccessary to use all the tables.
 CloseReasonTypes:  Id [ number]  Name [ text]  Description [ text] 
SELECT YEAR(CreationDate) AS Year, MONTH(CreationDate) AS Month, COUNT(CreationDate) AS Count FROM Posts WHERE PostTypeId = 1 GROUP BY MONTH(CreationDate), YEAR(CreationDate) ORDER BY YEAR(CreationDate), MONTH(CreationDate)