kiichiUntitled Query
    Updated 2022-06-20
    with pa1 as (
    select asset_id from algorand.asset
    where asset_name like 'Warrior Croc%'
    and creator_address = 'A62XRVE7ZWSXLAA4YDDI7GUMCHML2TT3JXFT3OWTVQAKOZSBGNT7FX5YQU'
    or creator_address = 'SRRIUGPVPPGST3KPH32XQXTE567G6LHCEX2IMHDRW2IWH3427UVWXRXHCQ'
    ),
    pa2 as (
    SELECT
    address,
    amount,
    asset_id
    from flipside_prod_db.algorand.account_asset
    where amount >0
    )
    SELECT
    b.address,
    sum (c.balance) as algo_balance,
    count (b.amount) as wildlife_warriors_amount
    from pa1 a
    left join pa2 b
    on a.asset_id = b.asset_id
    left join flipside_prod_db.algorand.account c
    on b.address=c.address
    group by b.address

    Run a query to Download Data