แท็กยอดนิยมสำหรับการเติบโตปี 2558 ถึง 2559 ไม่จำเป็นต้องใช้ตารางทั้งหมด
Trendy tags 2015 to 2016 growth.It is not neccessary to use all the tables.
 PostHistoryTypes:  Id [ number]  Name [ text] 
SELECT *, CAST(100.0 * (a.y2016 - a.y2015) / NULLIF(a.y2015, 0) AS FLOAT(18, 2)) AS growth FROM (SELECT t.TagName, COUNT(p.Id) AS postCount, SUM(CASE WHEN YEAR(p.CreationDate) = 2014 THEN 1 ELSE 0 END) AS y2014, SUM(CASE WHEN YEAR(p.CreationDate) = 2015 THEN 1 ELSE 0 END) AS y2015, SUM(CASE WHEN YEAR(p.CreationDate) = 2016 THEN 1 ELSE 0 END) AS y2016 FROM Posts AS p JOIN PostTags AS pTags ON pTags.PostId = p.Id JOIN Tags AS t ON pTags.TagId = t.Id WHERE YEAR(p.CreationDate) IN (2015, 2016, 2014) GROUP BY t.TagName) AS a WHERE a.y2014 >= '##Min2014##' AND 1.0 * a.y2016 >= 1.25 * a.y2015 AND a.postCount > '##MinQuestions##' ORDER BY growth DESC