mohammadhwallets that sorted based on balance less and more than 1 algo
    Updated 2022-06-14
    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
    Run a query to Download Data