1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for professors, theologians, and those interested in exegetical analysis of biblical texts

;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

fork query

created oct 29 22 Martin20528