Zero-score questions

Please login or register to vote for this query.

(click on this box to dismiss)

Zero-score questions, ordered by number of answers

Q&A for programmers

-- Zero-score questions
-- Zero-score questions, ordered by number of answers

WITH TotalPosts AS (
    SELECT CAST(COUNT(*) AS FLOAT) AS Count
    FROM Posts
    WHERE PostTypeId = 1
)
SELECT
    AnswerCount,
    Count(*) AS [#Questions],
    Round(100.0 * Count(*) / (SELECT Count FROM TotalPosts), 2) AS [%Questions]
FROM Posts
WHERE PostTypeId = 1 AND Score = 0
GROUP BY AnswerCount
ORDER BY AnswerCount

created may 9 11