User's Total Reputation Distribution

0

Please login or register to vote for this query.

(click on this box to dismiss)

Mathematics

Q&A for people studying math at any level and professionals in related fields

/* http://stackoverflow.com/a/233223/3184351 */
select u.range as [Reputation Range], count(*) as [Number of Users]
from (
  select case  
    when Reputation between 0 and 199 then '0-199'
    when Reputation between 200 and 19999 then '200-19999'
    else '20000+' end as range
  from Users) u
group by u.range

Enter Parameters

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