select count(address) as count_users,
case when balance < 1 then 'balance_lower_than_1_ALGO'
when balance between 1 and 10 then 'between_1_and_10'
when balance between 10 and 100 then 'between_10_and_100'
when balance between 100 and 1000 then 'between_100_and_1000'
when balance between 1000 and 10000 then 'between_1000_and_10000'
else 'larger_than_10000'
end as userse_balance
from flipside_prod_db.algorand.account
where address in(select distinct(ADDRESS) as address
from flipside_prod_db.algorand.account join flipside_prod_db.algorand.block on CREATED_AT=BLOCK_ID
where block_timestamp between '2022-05-01' and '2022-05-31')
group by userse_balance