select * from algorand.asset

where asset_name like 'Warrior Croc%'

and (creator_address = 'A62XRVE7ZWSXLAA4YDDI7GUMCHML2TT3JXFT3OWTVQAKOZSBGNT7FX5YQU' or

creator_address = 'SRRIUGPVPPGST3KPH32XQXTE567G6LHCEX2IMHDRW2IWH3427UVWXRXHCQ')

),

holders as (

SELECT ADDRESS, sum(amount) as holding_nft

from flipside_prod_db.algorand.account_asset

where asset_id in (SELECT asset_id from nfts)

and amount > 0

and ASSET_CLOSED = FALSE

GROUP BY ADDRESS

),

wallets as (

SELECT COUNT(DISTINCT ADDRESS) as wallets , date_trunc('month', b.block_timestamp) as date

from flipside_prod_db.algorand.account a

join flipside_prod_db.algorand.block b ON a.CREATED_AT = b.BLOCK_ID

where ACCOUNT_CLOSED = FALSE

and balance > 1

and ADDRESS in (select ADDRESS from holders)

GROUP BY date

SELECT * FROM wallets