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.UnansweredScore desc) as Rank,
rate.total_posts as NumPosts,
select sum(Posts.Score) as TotalScore,
sum(case when Posts.AcceptedAnswerId is NULL THEN Posts.Score ELSE 0 END) UnansweredScore,
count(PostId) as total_posts,
sum(case when Posts.AcceptedAnswerId is NULL THEN 1 ELSE 0 END) UnansweredPosts,
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.UnansweredScore desc