หัวข้อการเติบโตปีต่อปี ไม่จำเป็นต้องใช้ตารางทั้งหมด
Topic Growth Year on Year.It is not neccessary to use all the tables.
 CloseReasonTypes:  Id [ number]  Name [ text]  Description [ text] 
SELECT CAST(TIME_TO_STR(Posts.CreationDate, '%Y') AS TEXT(4)) + '-' + CAST(TIME_TO_STR(Posts.CreationDate, '%m') AS TEXT(2)) AS month_year, COUNT(*) AS tagcount FROM Posts INNER JOIN PostTags ON PostTags.PostId = Posts.Id INNER JOIN Tags ON Tags.Id = PostTags.TagId WHERE Tags.TagName = 'sas' AND TIME_TO_STR(Posts.CreationDate, '%Y') IN (2010, 2011, 2012, 2013) GROUP BY TIME_TO_STR(Posts.CreationDate, '%Y'), TIME_TO_STR(Posts.CreationDate, '%m') ORDER BY TIME_TO_STR(Posts.CreationDate, '%Y'), TIME_TO_STR(Posts.CreationDate, '%m')