project_name,

SUM(price_usd) AS total_sales_volume,

AVG (price_usd) As Average

FROM avalanche.nft.ez_nft_sales

WHERE platform_address = '0x00000000000000adc04c56bf30ac9d3c0aaf14dc'

AND block_timestamp >= '2024-01-01'

GROUP BY project_name, currency_symbol

ORDER BY total_sales_volume DESC

LIMIT 30