kiichiUntitled Query
    Updated 2022-06-20
    with pa1 as (
    SELECT
    address,
    amount
    from flipside_prod_db.algorand.account_asset
    where amount >0
    and asset_name like '%Warrior Croc%'
    )
    SELECT
    case when amount=1 then '1 Wildlife Warrior'
    when amount=2 then '2 Wildlife Warrior'
    when amount=3 then '3 Wildlife Warrior'
    when amount=4 then '4 Wildlife Warrior'
    when amount>4 then '+ 4 Wildlife Warrior'
    end as wildlife_warrior_amount,
    count(address) as wallet_amount
    from pa1
    group by wildlife_warrior_amount
    order by wallet_amount
    Run a query to Download Data