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