Reputation

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stellar Meta

Q&A about the site for developers and users of Stellar and the Stellar Distributed Exchange

;with data as (
  select TotalReputation = 
    case
      when Reputation <= 1 then '1'
      when Reputation > 1 and Reputation <= 1000 then '2 - 1000'
      when Reputation > 1000 and Reputation <= 2000 then '1001 - 2000'
      when Reputation > 2000 and Reputation <= 5000 then '2001 - 5000'
      when Reputation > 5000 and Reputation <= 10000 then '5001 - 10,000'
      when Reputation > 10000 and Reputation <= 20000 then '10,001 - 20,000'
      when Reputation > 20000 and Reputation <= 50000 then '20,001 - 50,000'
      when Reputation > 50000 and Reputation <= 100000 then '50,001 - 100,000'
      when Reputation > 100000 and Reputation <= 200000 then '100,001 - 200,000'
      when Reputation > 200000 and Reputation <= 500000 then '200,001 - 500,000'
      when Reputation > 500000 and Reputation <= 1000000 then '500,001 - 1,000,000'
      when Reputation > 1000000 then '> 1,000,000'
    end
  from Users
)
select 
  TotalReputation,
  count(1) Count
from data
group by TotalReputation

Enter Parameters

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