Q&A about the site for physical fitness professionals, athletes, trainers, and those providing health-related needs
rate.TagName as Tag,
row_number() over (order by rate.Rate desc) as rank,
rate.posts as NumPosts,
rate.Rate as QuestionsInMay
(select sum(Posts.Score) as Rate, count(PostId) as posts, TagName
Tags, PostTags, Posts
where Tags.Id = PostTags.TagId and Posts.Id = PostId
-- and Posts.CreationDate < '2010-06-01'
and Posts.CreationDate > '2018-01-01'
and Posts.AcceptedAnswerId is NULL
group by TagName) as rate
order by rate.rate desc