Top 10 in-demand technologies over the last year, fixed

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 TOP 10
  COUNT(*) AS QuestionCount,
  TagName
FROM Posts Question
JOIN PostTags ON PostTags.PostId = Question.Id
JOIN Tags ON Tags.Id = PostTags.TagId
WHERE
  Question.CreationDate < DATEFROMPARTS(YEAR(GETDATE()) + 1, 1, 1) AND
  Question.CreationDate > DATEFROMPARTS(YEAR(GETDATE()), 1, 1)
GROUP BY TagName
ORDER BY QuestionCount DESC

Enter Parameters

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