iboo-jbj2MVAlgo wallets count - by balance
    Updated 2022-06-16
    select
    case
    when balance > 0 and balance <= 1 then 'balance <= 1'
    when balance > 1 then 'balance > 1' else null end as tier,
    count (distinct ADDRESS) as addresses
    FROM flipside_prod_db.algorand.account
    where ACCOUNT_CLOSED = 'FALSE'
    group by 1
    Run a query to Download Data