User reputation by percentage


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",
    Cast(min(reputation) as varchar(400)) + '-' + Cast(max(reputation) as varchar(400)) as "Rep"
FROM users
GROUP BY [reputation] / ##SIZE?10##
ORDER BY min(reputation) ASC

Enter Parameters

Switch to meta site
loading Hold tight while we fetch your results