shahdadi-9ptm8Ybalance of wildlife warriors holder
    Updated 2022-06-19
    with id as(select asset_id
    from algorand.asset
    where asset_name like 'Warrior Croc%'
    and (creator_address = 'A62XRVE7ZWSXLAA4YDDI7GUMCHML2TT3JXFT3OWTVQAKOZSBGNT7FX5YQU' or creator_address = 'SRRIUGPVPPGST3KPH32XQXTE567G6LHCEX2IMHDRW2IWH3427UVWXRXHCQ')
    )
    select distinct b.address,balance
    from flipside_prod_db.algorand.account_asset b join flipside_prod_db.algorand.account c on b.address=c.address where asset_id in (select asset_id from id) and ASSET_CLOSED='FALSE'
    order by balance desc
    Run a query to Download Data