จำนวนโพสต์ใหม่สำหรับภาษายอดนิยมต่อปี ไม่จำเป็นต้องใช้ตารางทั้งหมด
Number of new posts for the most popular languages per year.It is not neccessary to use all the tables.
 ReviewTaskResultTypes:  Id [ number]  Name [ text]  Description [ text] 
SELECT Tags.TagName AS Tag, YEAR(Posts.CreationDate) AS Year, COUNT(*) AS Count FROM PostTags JOIN Tags ON PostTags.TagId = Tags.Id AND Tags.TagName IN ('c#', 'java', 'javascript', 'php', 'android', 'jquery', 'python') JOIN Posts ON PostTags.PostId = Posts.Id WHERE YEAR(Posts.CreationDate) < 2014 GROUP BY YEAR(Posts.CreationDate), Tags.TagName