amirozaholders count
    Updated 2022-06-21
    with ww_nft as (select distinct asset_id id
    from algorand.asset
    where asset_name like 'Warrior Croc%'
    and (creator_address = 'A62XRVE7ZWSXLAA4YDDI7GUMCHML2TT3JXFT3OWTVQAKOZSBGNT7FX5YQU'
    or creator_address = 'SRRIUGPVPPGST3KPH32XQXTE567G6LHCEX2IMHDRW2IWH3427UVWXRXHCQ'))
    select address, count(*) nft_hold
    from algorand.account_asset
    where ASSET_CLOSED='FALSE' and AMOUNT>0
    and ASSET_ID in (select id from ww_nft)
    group by 1
    order by 2 desc
    Run a query to Download Data