Q&A for professional and enthusiast programmers
SELECT datepart(yyyy, Answer.CreationDate) as y, TagName, COUNT(*) AS AnswerCount FROM Posts Answer RIGHT JOIN Posts Question ON Question.Id = Answer.ParentId RIGHT JOIN PostTags ON PostTags.PostId = Question.Id RIGHT JOIN Tags ON Tags.Id = PostTags.TagId WHERE Answer.PostTypeId = 2 AND TagName in ('jooq', 'hibernate', 'jpa', 'querydsl', 'mybatis') AND datepart(yyyy, Answer.CreationDate) > 2020 GROUP BY TagName, datepart(yyyy, Answer.CreationDate) ORDER BY y DESC, AnswerCount DESC