ORM popularity

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

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

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results