Q&A about the site for builders and users of networked sensors and control devices in the contexts of smart homes, industry automation, or environmental sensors
rate.TagName as Tag,
row_number() over (order by rate.Rate desc) as MayRank,
rate.Rate as QuestionsInMay
(select sum(Posts.Score) as Rate, 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