MLDZMNwildliffe-algo balance
    Updated 2022-06-24
    with tb1 as (select *
    from algorand.asset
    where asset_name like 'Warrior Croc%'
    and (creator_address = 'A62XRVE7ZWSXLAA4YDDI7GUMCHML2TT3JXFT3OWTVQAKOZSBGNT7FX5YQU' or creator_address = 'SRRIUGPVPPGST3KPH32XQXTE567G6LHCEX2IMHDRW2IWH3427UVWXRXHCQ')
    ),

    tb2 as (SELECT
    *
    from flipside_prod_db.algorand.account_asset
    where ASSET_ID in (select ASSET_ID from tb1)
    )

    SELECT
    case
    when BALANCE between 0 and 100 then '0-100 ALGOs'
    when BALANCE between 100 and 500 then '100-500 ALGOs'
    when BALANCE between 500 and 1500 then '500-1500 ALGOs'
    when BALANCE>=1500 then 'above 1500 ALGOs'
    end as distribution,

    count(distinct ADDRESS) wallets

    from flipside_prod_db.algorand.account
    where ADDRESS in (select ADDRESS from tb2)
    group by 1

    Run a query to Download Data