Stack Exchange
log in help

Reputation Visualizer

2

Please login or register to vote for this query.

(click on this box to dismiss)

Distribution of reputation among all users, as a percentage of total users. You can see some interesting trends by looking at the graph. The default parameters should make a great starting point, but if you want change them, be careful not to set the step-wise granularity too low; otherwise, the query will timeout before it finishes executing.

Amateur Radio

Q&A for amateur radio enthusiasts

Declare @totalUserCount Decimal;

Select @totalUserCount = count(1) from USERS;

Select Reputation,
       -- Count(Id) as "Users",
       (Count(Id) / @totalUserCount) * 100 as "Percentage"
    From USERS 
    -- WHERE Reputation > 101 AND Reputation < 10000
    Group By Reputation
    Order by Reputation Desc
    ;
view current version

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results