instruction: Trend of popular tags ('dojo', 'jquery', 'java') on stats.SE.
response: 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