strawbettywallets that have more than 1 Algo
    Updated 2022-06-16
    with base as (select address
    from flipside_prod_db.algorand.account a
    join algorand.block b
    on a.created_at = b.block_id
    where block_timestamp >= '2022-05-01'
    and block_timestamp <= '2022-05-31'),


    base2 as (select a.address,
    sum(balance) as algo_balance, case
    when algo_balance <= 1 then 'algo balance <= 1'
    when algo_balance > 1 then 'algo balance > 1'
    end as algo_balance_ranges,
    case
    when algo_balance <= 1 then '0'
    when algo_balance > 1 then '1'
    end as ordering
    from base a
    join algorand.account b
    on a.address = b.address
    group by 1)

    select algo_balance_ranges,
    ordering,
    count(distinct(address)) as count_wallets
    from base2
    group by 1,2
    order by 2
    Run a query to Download Data