Score Distribution of All Answers

0

Please login or register to vote for this query.

(click on this box to dismiss)

This query shows all scores currently in the system, and the number of questions with such a score.

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT
    'any' AS Type,
    Score,
    Count(*) AS Count,
    Str(Count(*) * 100.0 / Sum(Count(*)) OVER(), 10, 1) + '%' AS Percentage
FROM
    Posts
WHERE
    PostTypeId = 2
GROUP BY
    Score
ORDER BY
    Score

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results