Retrieve tags and unanswered questions count, ordered by descending count

0

Please login or register to vote for this query.

(click on this box to dismiss)

Psychology and Neuroscience Meta

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

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results