Count users with a specific reputation.
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'
-- 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##
--Keep this descending