with acounts as (

SELECT address, COUNT(*) as cnt

FROM flipside_prod_db.algorand.account_asset

WHERE asset_id IN (

-- list of verified CGF NFTs asset_id

SELECT asset_id

FROM flipside_prod_db.algorand.asset

WHERE asset_name LIKE 'CGF%' AND

asset_deleted = FALSE AND

closed_at IS NULL AND

creator_address LIKE 'GOOSE%'

) AND

amount > 0 AND

asset_closed = FALSE AND

asset_last_removed IS NULL

GROUP BY address

ORDER BY cnt DESC)

SELECT count(address)

from acounts

WHERE cnt > 1