Q&A for people who love being outdoors enjoying nature and wilderness, and learning about the required skills and equipment
select num.TagName as Tag, row_number() over (order by num.Num desc) as TotalRank, num.Num as QuestionsTotal from (select count(PostId) as Rate, TagName from Tags, PostTags, Posts where Tags.Id = PostTags.TagId and Posts.Id = PostId and Posts.CreationDate > getdate() - 10 group by TagName) as rate INNER JOIN (select count(PostId) as Num, TagName from Tags, PostTags, Posts where Tags.Id = PostTags.TagId and Posts.Id = PostId and Posts.Tags like '%<java>%' group by TagName having count(PostId) > 10000) as num ON rate.TagName = num.TagName order by rate.rate desc ;