Distribution of users by reputation, double logarithmic scale

1

Please login or register to vote for this query.

(click on this box to dismiss)

Amateur Radio

Q&A for amateur radio enthusiasts

WITH LogRep AS (
  SELECT POWER(##LogBase:FLOAT?1.2##,
      CAST(
        LOG(1.0 * Reputation)/LOG(##LogBase##) AS INT
      )
    ) AS Reputation
  FROM Users
  WHERE
    Reputation BETWEEN
      ##MinimalRepShown:INT?202## AND ##MaximalRepShown:INT?35000##
)
SELECT
  Reputation,
  LOG(1.0 * COUNT(*))/LOG(10.0) AS N
FROM LogRep
GROUP BY Reputation
ORDER BY Reputation

Enter Parameters

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