Q&A about the site for practitioners, researchers, and students in cognitive science, psychology, neuroscience, and psychiatry
select t.TagName, COUNT(q.Id) as countofUnAnsweredQuestions from Posts q inner join PostTags AS pt ON pt.PostId = q.Id inner join Tags as t on pt.tagId = t.Id where (select count(*) from Posts a where a.ParentId = q.Id and a.Score > 0) = 0 and q.CommunityOwnedDate is null and q.ClosedDate is null and q.ParentId is null and q.AcceptedAnswerId is null GROUP BY t.TagName ORDER BY countofUnAnsweredQuestions desc