project_name,

SUM(amount_usd) AS volume_usd

FROM

sei.nft.ez_nft_sales

platform_name = 'pallet'

AND

amount_usd IS NOT NULL

GROUP BY

project_name

ORDER BY

volume_usd DESC

LIMIT 10;