Breakdown of users by reputation groups

1

Please login or register to vote for this query.

(click on this box to dismiss)

Anime and Manga Meta

Q&A about the site for anime and manga fans

---by changing the parameter you decide how the users are divided into groups
---for example, if rep=10, we're looking at users with 0 to 9 points, users with 10 to 19 points, etc.

;with repgroups_cte AS (
SELECT
  Id AS uid,
  CAST(reputation/##rep?100## 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 sites:
loading Hold tight while we fetch your results