Top 10 in-demand technologies over the last year

0

Please login or register to vote for this query.

(click on this box to dismiss)

Bicycles Meta

Q&A about the site for people who build and repair bicycles, people who train cycling, or commute on bicycles

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 ASC

Enter Parameters

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