select *

from algorand.asset

where asset_name like 'Warrior Croc%'

and (creator_address = 'A62XRVE7ZWSXLAA4YDDI7GUMCHML2TT3JXFT3OWTVQAKOZSBGNT7FX5YQU'

or creator_address = 'SRRIUGPVPPGST3KPH32XQXTE567G6LHCEX2IMHDRW2IWH3427UVWXRXHCQ')

),

wwowners as (select * from flipside_prod_db.algorand.account_asset where asset_id in (select asset_id from wwtable) and amount >0

order by asset_name)

select address,

count (asset_id) as Wildlife_Warriors_Count

from wwowners

group by 1

order by 2 desc