ErsvanALGO balance per wallet with nft hold
    Updated 2022-06-21
    SELECT
    AA.ADDRESS,
    COUNT(*) NFTS,
    AC.BALANCE
    FROM flipside_prod_db.algorand.account_asset AS AA
    JOIN flipside_prod_db.algorand.account AS AC ON AC.ADDRESS = AA.ADDRESS
    JOIN flipside_prod_db.algorand.block AS BL ON BL.BLOCK_ID = AC.CREATED_AT
    WHERE AA.ASSET_ID IN (
    select ASSET_ID from algorand.asset where asset_name like 'Warrior Croc%' and (creator_address = 'A62XRVE7ZWSXLAA4YDDI7GUMCHML2TT3JXFT3OWTVQAKOZSBGNT7FX5YQU' or creator_address = 'SRRIUGPVPPGST3KPH32XQXTE567G6LHCEX2IMHDRW2IWH3427UVWXRXHCQ')
    )
    AND AMOUNT !=0
    GROUP BY 1, 3
    ORDER BY 2 DESC
    Run a query to Download Data