Q&A for professional and enthusiast programmers
select TagName, count(*) c from Posts join PostTags pt on pt.PostId = Posts.Id join Tags t on t.Id = pt.TagId where TagId in ( select top 10 Id from Tags order by Count desc ) and CreationDate > DATEADD(year, -1, GetDate()) group by tagName order by c desc