instruction: Top 1000 most viewed question in a given tag per year.
response: SELECT YEAR(p.CreationDate) AS Year, p.Id AS "post_link", p.ViewCount FROM Posts AS p INNER JOIN PostTags AS pt ON p.Id = pt.PostId INNER JOIN Tags AS t ON t.Id = pt.TagId WHERE p.PostTypeId = 1 AND t.TagName = '##TagName##' GROUP BY YEAR(p.CreationDate), p.Id, p.ViewCount ORDER BY ROW_NUMBER() OVER (PARTITION BY YEAR(p.CreationDate) ORDER BY p.ViewCount DESC) LIMIT 1000