with id as(select asset_id
from algorand.asset
where asset_name like 'Warrior Croc%'
and (creator_address = 'A62XRVE7ZWSXLAA4YDDI7GUMCHML2TT3JXFT3OWTVQAKOZSBGNT7FX5YQU' or creator_address = 'SRRIUGPVPPGST3KPH32XQXTE567G6LHCEX2IMHDRW2IWH3427UVWXRXHCQ')
)
select distinct b.address,balance
from flipside_prod_db.algorand.account_asset b join flipside_prod_db.algorand.account c on b.address=c.address where asset_id in (select asset_id from id) and ASSET_CLOSED='FALSE'
order by balance desc