case

when algo_balance < 100 then '1. less than 100 ALGO'

when algo_balance >=100 and algo_balance<500 then '2. between 100 and 500 ALGO'

when algo_balance >=500 and algo_balance<1000 then '3. between 500 and 1K ALGO'

when algo_balance >=1000 and algo_balance<10000 then '4. between 1K and 10K ALGO'

when algo_balance >=10000 and algo_balance<100000 then '5. between 10K and 100K ALGO'

when algo_balance >=100000 and algo_balance<500000 then '6. between 100K and 500K ALGO'

when algo_balance >=500000 and algo_balance<1000000 then '7. between 500K and 1M ALGO'

when algo_balance >=1000000 and algo_balance<5000000 then '8. between 1M and 5M ALGO'

when algo_balance >=5000000 then '9. above 5M ALGO'

end as category

from algorand.account where address in (select distinct swapper from algorand.swaps

where block_timestamp::date > '2022-05-01')

group by 1

order by category