kiichiALGO balances of wallets that own a wildlife warrior
    Updated 2022-06-19
    with pa1 as (
    select
    address
    from flipside_prod_db.algorand.account_asset
    where asset_name like '%Warrior Croc%'
    and amount >0
    ),
    pa2 as (
    SELECT
    balance,
    created_at,
    address
    from flipside_prod_db.algorand.account
    )
    SELECT
    a.address,
    b.balance,
    b.created_at,
    b.address
    from pa1 a
    left join pa2 b
    on a.address=b.address

    Run a query to Download Data