Q&A for professional and enthusiast programmers
SELECT TOP 10 COUNT(*) AS QuestionCount, TagName FROM Posts Question JOIN PostTags ON PostTags.PostId = Question.Id JOIN Tags ON Tags.Id = PostTags.TagId WHERE Question.CreationDate < DATEFROMPARTS(YEAR(GETDATE()) + 1, 1, 1) AND Question.CreationDate > DATEFROMPARTS(YEAR(GETDATE()), 1, 1) GROUP BY TagName ORDER BY QuestionCount DESC