with score <= 0, low views, no answers
Q&A for professional and enthusiast programmers
-- 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.Id = p.AcceptedAnswerId AND a.Score = 0 GROUP BY t.TagName HAVING COUNT(*) > 2000 ORDER BY 2 DESC