WITH Asset_id AS (
select
ASSET_ID,
ASSET_NAME
from algorand.asset
where asset_name like 'Warrior Croc%'
and (creator_address = 'A62XRVE7ZWSXLAA4YDDI7GUMCHML2TT3JXFT3OWTVQAKOZSBGNT7FX5YQU'
or creator_address = 'SRRIUGPVPPGST3KPH32XQXTE567G6LHCEX2IMHDRW2IWH3427UVWXRXHCQ'))
SELECT
A.ADDRESS AS NFT_owners,
COUNT(DISTINCT B.ASSET_ID) AS Number_of_NFTs,
C.BALANCE
FROM flipside_prod_db.algorand.account_asset A INNER JOIN Asset_id B ON A.ASSET_ID=B.ASSET_ID
INNER JOIN flipside_prod_db.algorand.account C ON A.ADDRESS=C.ADDRESS
WHERE AMOUNT <> 0
GROUP BY 1,3
ORDER BY 2 DESC