SELECT COUNT(*) as "Count", COUNT(*) * 100.0 / sum(count(...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT COUNT(*) as "Count", 
    COUNT(*) * 100.0 / sum(count(*)) over() as "Percentage",
    min(reputation) as "Rep" 
FROM users
GROUP BY [reputation] / 1000
ORDER BY min(reputation) ASC

Enter Parameters

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