Breakdown of users by reputation groups - log

1

Please login or register to vote for this query.

(click on this box to dismiss)

Writing

Q&A for the craft of professional writing, including fiction, non-fiction, technical, scholarly, and commercial writing

;with repgroups_cte AS (
SELECT
  Id AS uid,
  CAST(FLOOR(LOG(Reputation, ##base?10##)) AS int) AS rep
  FROM Users
  WHERE (Reputation>=##min?125##)
)

SELECT
  rep,
  COUNT(uid) AS [Count]
FROM repgroups_cte
GROUP BY rep
ORDER BY rep DESC

Enter Parameters

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