balances as (

select

address,

sum(rewards_total) as total_rewards

from algorand.account

group by 1

order by 2 desc

),

distribution as (

case when total_rewards >=1000000 then 'whales: above 1M'

when total_rewards <1000000 and total_rewards >= 50000 then 'Little whales: between 50k and 1M'

when total_rewards <50000 and total_rewards >= 10000 then 'Fishes: between 50k and 10k'

when total_rewards <10000 and total_rewards >= 1000 then 'Frogs: between 1k and 10k'

when total_rewards <1000 and total_rewards >=10 then 'Crabs: between 10 and 1k'

when total_rewards <10 and total_rewards>=1 then 'Poors: between 1 and 10'

when total_rewards <1 and total_rewards>0 then 'Homeless: below 1'

end as distributions

from balances

)

SELECT

distinct distributions,

sum(1) as wallets

from distribution where distributions is not null

group by 1

order by 2