แนวโน้มของแท็กยอดนิยม ('dojo', 'jquery', 'java') บน stats.SE.ไม่จำเป็นต้องใช้ตารางทั้งหมด
Trend of popular tags ('dojo', 'jquery', 'java') on stats.SE.It is not neccessary to use all the tables.
 ReviewTaskTypes:  Id [ number]  Name [ text]  Description [ text] 
SELECT YEAR(CreationDate) AS y, TagName, COUNT(*) FROM Posts AS p JOIN PostTags AS pt ON p.Id = pt.PostId JOIN (SELECT tb.Id, tb.TagName, COUNT(*) AS cnt FROM PostTags AS b LEFT OUTER JOIN Tags AS tb ON b.TagId = tb.Id GROUP BY tb.Id, tb.TagName HAVING COUNT(*) > 1000 AND tb.TagName IN ('dojo', 'jquery', 'java')) AS t ON pt.TagId = t.Id GROUP BY YEAR(CreationDate), TagName ORDER BY TagName, y