nft_address, project_name,

COUNT(DISTINCT tx_hash) AS total_unique_transactions

FROM

optimism.nft.ez_nft_sales

GROUP BY

nft_address,project_name

ORDER BY

total_unique_transactions DESC

LIMIT 10;