Q&A for apps, scripts, and development with the Stack Exchange API
SELECT TagId, TagName, row_number() OVER(ORDER BY cnt DESC) AS a FROM ( SELECT pt.TagId, t.TagName, COUNT(*) AS cnt FROM PostTags pt JOIN Posts p ON pt.PostId = p.Id JOIN Tags t ON pt.TagId = t.Id WHERE datepart(year, p.CreationDate) = 2017 GROUP BY pt.TagId, t.TagName ) temp