Zero-score questions

0

Please login or register to vote for this query.

(click on this box to dismiss)

Zero-score questions, ordered by number of answers

Stack Overflow

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

Enter Parameters

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