Tags with a high proportion of unanswered questions

2

Please login or register to vote for this query.

(click on this box to dismiss)

with score <= 0, low views, no answers

Stack Overflow

Q&A for programmers

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

SELECT t.TagName
, 100 * CAST( COUNT(p.id) AS FLOAT ) / COUNT(*) AS '% Unanswered'
, COUNT( p.id ) AS Unanswered
, COUNT( * ) AS Posts
FROM Tags t
LEFT JOIN
     PostTags pt
ON   t.id = pt.TagId
LEFT OUTER JOIN
     Posts p
ON   pt.PostId = p.id
AND p.PostTypeId = 1
AND p.ViewCount < 500
AND ( p.AnswerCount < 1 OR p.AnswerCount IS NULL )
GROUP BY t.TagName
HAVING COUNT(*) > 2000
ORDER BY 2 DESC

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results
:records returned in :time ms:cached