Count users with a specific reputation.
Q&A for people looking to bypass life's everyday problems with simple tricks
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