flipside

    distribution of NFT amount of wallets that own a wildlife warrior
    kasadeghdistribution of NFT amount of wallets that own a wildlife warrior
    Updated 2022-06-23
    select "NFT AMOUNT", count(*) as "Total number of wallets with this NFT AMOUNT "
    from
    (
    select acc.ADDRESS, sum(AMOUNT) as "NFT AMOUNT"
    from algorand.asset as ass
    join flipside_prod_db.algorand.account_asset as acc_ass on ass.asset_id = acc_ass.asset_id
    join flipside_prod_db.algorand.account as acc on acc.address = acc_ass.address
    join flipside_prod_db.algorand.block as bl on acc.created_at = bl.block_id
    where ass.asset_name like 'Warrior Croc%' and
    (ass.creator_address = 'A62XRVE7ZWSXLAA4YDDI7GUMCHML2TT3JXFT3OWTVQAKOZSBGNT7FX5YQU' or ass.creator_address = 'SRRIUGPVPPGST3KPH32XQXTE567G6LHCEX2IMHDRW2IWH3427UVWXRXHCQ')
    group by acc.ADDRESS
    )
    where "NFT AMOUNT"!=0
    group by 1
    order by 1


    Run a query to Download Data