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