Most popular tags in last year

0

Please login or register to vote for this query.

(click on this box to dismiss)

Android Enthusiasts

Q&A for enthusiasts and power users of the Android operating system

SELECT
  COUNT(PostId) AS Rate, TagName, year(Posts.CreationDate) as [year]
FROM
  Tags, PostTags, Posts
WHERE 
  Tags.TagName in (
    'python', 
    'matlab', 
    'java',
    'scala',
    'r', 
    'sas',
    'julia',
    'f#'
  )
  AND
  Tags.Id = PostTags.TagId and Posts.Id = PostId
GROUP BY 
  TagName, year(Posts.CreationDate)
ORDER BY
  Rate DESC

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results