1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professionals, academics, and students working within the systems development life cycle

select 
       TagName as Tag,
       row_number() over (order by Rate desc) as TotalRank,
       Rate as TotalQuestions,
       TotalViews,
       TotalComments,
       TotalAnswers
from

(select count(PostId) as Rate, TagName, sum(cast(ViewCount as bigint)) as TotalViews, sum(cast(CommentCount as bigint)) as TotalComments, count(AcceptedAnswerId) as TotalAnswers
from
  Tags, PostTags, Posts
where Tags.Id = PostTags.TagId and Posts.Id = PostId
group by TagName) as tq
where Rate > 50

fork query

edited feb 19 19

created feb 19 19 gkeyston