Tags with a high proportion of unanswered questions

0

Please login or register to vote for this query.

(click on this box to dismiss)

with score <= 0, low views, no answers

Russian Language

Q&A for students, teachers, and linguists wanting to discuss the finer points of the Russian language

-- Tags with a high proportion of unanswered questions
-- with score <= 0, low views, no answers

SELECT t.TagName, COUNT(*), COUNT(a.id)
FROM Tags t
LEFT JOIN
     PostTags pt
ON   t.id = pt.TagId
LEFT OUTER JOIN
     Posts p
ON   pt.PostId = p.id
AND  p.AcceptedAnswerId != 0
LEFT JOIN
     Posts a
ON   a.ParentId = p.AcceptedAnswerId
AND a.Score = 0
GROUP BY t.TagName
HAVING COUNT(*) > 2000
ORDER BY 2 DESC

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results