1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for designers and implementers of computer programming languages

SELECT
    COUNT(*) AS total_rows,
    COUNT(CASE WHEN Reputation > 10897 THEN 1 END) AS count_above_threshold,
    COUNT(CASE WHEN Reputation > 10897 THEN 1 END) * 100.0 / COUNT(*) AS percentage_above_threshold
FROM
    Users;

fork query

edited jul 28 Carlos Robles

created aug 5 12 Chris-s