platform_name,

COUNT(DISTINCT tx_hash) AS total_unique_transactions

FROM

optimism.nft.ez_nft_sales

GROUP BY

platform_name;