Popular Languages by Year and Month

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
 Tags.TagName,
 COUNT(Posts.Id) as 'TagCount',
 MONTH(Posts.CreationDate) as 'MonthOfYear',
 YEAR(Posts.CreationDate) as 'Year'
FROM PostTags
INNER JOIN Tags ON Tags.Id = PostTags.TagId
INNER JOIN Posts ON Posts.Id = PostTags.PostId
WHERE TagName IN ('python','java','go','node.js','php','dart')
GROUP BY 
 Tags.TagName,
 MONTH(Posts.CreationDate),
 YEAR(Posts.CreationDate)
ORDER BY TagName

Enter Parameters

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