StackOverflow Cloud Platform Tag Popularity in Most Recent Month

1

Please login or register to vote for this query.

(click on this box to dismiss)

Chess

Q&A for serious players and enthusiasts of chess

-- Most popular StackOverflow tags in May 2010

select 
       num.TagName as Tag,
       row_number() over (order by rate.Rate desc) as MonthRank,
       row_number() over (order by num.Num desc) as TotalRank,
       rate.Rate as QuestionsInMonth,
       num.Num as QuestionsTotal,
       rate.MonthViews,
       num.TotalViews,
       rate.MonthComments,
       num.TotalComments,
       rate.MonthAnswers,
       num.TotalAnswers

from

(select count(PostId) as Rate, TagName, sum(ViewCount) as MonthViews, sum(CommentCount) as MonthComments, sum(AnswerCount) as MonthAnswers
from
  Tags, PostTags, Posts
where Tags.Id = PostTags.TagId and Posts.Id = PostId
and Posts.CreationDate < DATEADD(mm, DATEDIFF(mm, 0, GETDATE()), 0)
and Posts.CreationDate > DATEADD(mm, DATEDIFF(mm, 0, GETDATE()) - 1, 0)
group by TagName) as rate

INNER JOIN

(select count(PostId) as Num, TagName, sum(ViewCount) as TotalViews, sum(CommentCount) as TotalComments, sum(AnswerCount) as TotalAnswers
from
  Tags, PostTags, Posts
where Tags.Id = PostTags.TagId and Posts.Id = PostId
group by TagName
having count(PostId) > 800)
as num ON rate.TagName = num.TagName
where num.TagName in ('amazon-web-services', 'azure', 'google-cloud-platform')
order by rate.rate desc
;

Enter Parameters

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