การเติบโตแบบปีต่อปีสำหรับแท็ก ไม่จำเป็นต้องใช้ตารางทั้งหมด
Year on year growth by month for a tag.It is not neccessary to use all the tables.
 Posts:  Id [ number]  PostTypeId [ number]  AcceptedAnswerId [ number]  ParentId [ number]  CreationDate [ time]  DeletionDate [ time]  Score [ number]  ViewCount [ number]  Body [ text]  OwnerUserId [ number]  OwnerDisplayName [ text]  LastEditorUserId [ number]  LastEditorDisplayName [ text]  LastEditDate [ time]  LastActivityDate [ time]  Title [ text]  Tags [ text]  AnswerCount [ number]  CommentCount [ number]  FavoriteCount [ number]  ClosedDate [ time]  CommunityOwnedDate [ time]  ContentLicense [ text] 
SELECT ((YEAR(CURRENT_TIMESTAMP()) - YEAR(P.CreationDate)) * 12 + MONTH(CURRENT_TIMESTAMP()) - MONTH(P.CreationDate)) AS monthsAgo, COUNT(*) FROM Posts AS P INNER JOIN PostTags AS PT ON P.Id = PT.PostId INNER JOIN Tags AS T ON PT.TagId = T.Id WHERE ((YEAR(CURRENT_TIMESTAMP()) - YEAR(P.CreationDate)) * 12 + MONTH(CURRENT_TIMESTAMP()) - MONTH(P.CreationDate)) > 0 AND ((YEAR(CURRENT_TIMESTAMP()) - YEAR(P.CreationDate)) * 12 + MONTH(CURRENT_TIMESTAMP()) - MONTH(P.CreationDate)) < 24 AND T.TagName = 'angularjs' GROUP BY ((YEAR(CURRENT_TIMESTAMP()) - YEAR(P.CreationDate)) * 12 + MONTH(CURRENT_TIMESTAMP()) - MONTH(P.CreationDate)) ORDER BY ((YEAR(CURRENT_TIMESTAMP()) - YEAR(P.CreationDate)) * 12 + MONTH(CURRENT_TIMESTAMP()) - MONTH(P.CreationDate))