nft_address,

project_name,

SUM(price_usd) AS total_transaction_volume_usd

FROM

optimism.nft.ez_nft_sales

GROUP BY

nft_address,project_name

ORDER BY

total_transaction_volume_usd DESC

LIMIT 10;