0

Please login or register to vote for this query.

(click on this box to dismiss)

The below query will find the tags and corresponding count of unanswered questions. The tags will be ordered in the descending order i.e., the tag with most number of unanswered questions will be at the top, followed by second next tag etc.

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

fork query

edited apr 1 20 Venkataraman R

created apr 1 20 anonymous