FROM flipside_prod_db.algorand.asset

WHERE asset_name LIKE 'CGF%' AND

asset_deleted = FALSE AND

closed_at IS NULL

GROUP BY creator_address

ORDER BY num_of_asset_created DESC