Q&A for passionate videogamers on all platforms
-- Most popular StackOverflow tags in May 2010 select rate.TagName as Tag, rate.mois,rate.an, rate.Rate as Questions from (select count(PostId) as Rate, TagName,datepart(month,CreationDate) as mois ,datepart(year,CreationDate) as an from Tags, PostTags, Posts where Tags.Id = PostTags.TagId and Posts.Id = PostId and Posts.CreationDate < '2022-06-01' and Posts.CreationDate > '2022-05-01' group by TagName,datepart(month,CreationDate),datepart(year,CreationDate)) as rate --cast(CreationDate as date) INNER JOIN (select count(PostId) as Num, TagName from Tags, PostTags, Posts where Tags.Id = PostTags.TagId and Posts.Id = PostId group by TagName having count(PostId) > 5000) as num ON rate.TagName = num.TagName order by rate.rate desc ;