0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for experienced flyers, pilots, and builders of drones and model aircraft

SELECT TOP 10
  COUNT(*) AS AnswerCount,
  TagName
FROM Posts Answer
JOIN Posts Question ON Question.Id = Answer.ParentId
JOIN PostTags ON PostTags.PostId = Question.Id
JOIN Tags ON Tags.Id = PostTags.TagId
WHERE
  Answer.PostTypeId = 2 AND
  Answer.CreationDate < DATEFROMPARTS(YEAR(GETDATE()) + 1, 1, 1) AND
  Answer.CreationDate > DATEFROMPARTS(YEAR(GETDATE()), 1, 1)
GROUP BY TagName
ORDER BY AnswerCount DESC

view current version

edited jun 17

created jun 17 Vlad.Mihalcea