WITH UniqueHolders AS (
SELECT
nft_address,
project_name,
COUNT(DISTINCT buyer_address) + COUNT(DISTINCT seller_address) AS total_unique_holders
FROM
optimism.nft.ez_nft_sales
GROUP BY
nft_address, project_name
)
SELECT
nft_address,
project_name,
total_unique_holders
FROM
UniqueHolders
ORDER BY
total_unique_holders DESC
LIMIT 10;