1

Please login or register to vote for this query.

(click on this box to dismiss)

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

fork query

edited aug 24 19

created aug 24 19 Zoe