with score <= 0, low views, no answers
Q&A about the site for people who build and repair bicycles, people who train cycling, or commute on bicycles
-- Tags with a high proportion of unanswered questions -- with score <= 0, low views, no answers SELECT Questions / 1000, SUM( Questions ) FROM ( SELECT t.TagName , COUNT(*) AS 'Questions' , CAST( COUNT(a.id) AS FLOAT ) / COUNT(*) AS 'AcceptedPercent' 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(*) > 1000 ) x GROUP BY Questions / 1000