User Count: Reputation Groups

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

Cognitive Sciences Meta

Q&A about the site for practitioners, researchers, and students in cognitive science, psychology, neuroscience, and psychiatry

--
--
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

Enter Parameters

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