Number of Users with Reputation <= N

1

Please login or register to vote for this query.

(click on this box to dismiss)

For each unique reputation value N, this query retrieves the number of uses with reputation <= N. Click the graph tab for interesting pictures.

Mathematics

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

SELECT 
  Reputation, 
  SUM(COUNT(*)) OVER(
    ORDER BY Reputation 
    ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS UserCount
FROM 
  Users
GROUP BY Reputation
ORDER BY Reputation

Enter Parameters

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