2

Please login or register to vote for this query.

(click on this box to dismiss)

Count users with a specific reputation. from http://data.stackexchange.com/stackoverflow/query/153752/reputation-by-user-count

Q&A for linguists, teachers, and students wanting to discuss the finer points of the Latin language

--
--
SELECT TOP 100
  reputation AS 'Reputation',
  COUNT(*) AS 'User Count'
  
 FROM
   users
     -- Input 100. Result is counts of users with 100 rep down to 1 rep
     -- Input 200. Result is counts of users with 200 rep down to 101 rep
     -- Input higher reputation. Result is counts of few to one user and not all consecutve.
     Where reputation <=  ##MaxReputation##
     
 GROUP BY
   reputation
   
 ORDER BY
   --COUNT(*) DESC;
   
   --Keep this descending
   reputation desc

fork query

edited dec 15 13

created dec 15 13 jon.doe12449