SELECT
IFF((PROJECT_NAME IS NOT NULL) ,PROJECT_NAME ,NFT_ADDRESS) AS "NFT Collection",
SUM(PRICE) AS "24h ETH Volume",
COUNT(*) AS "Number of Sales"
FROM
base.nft.ez_nft_sales
WHERE BLOCK_TIMESTAMP >= DATEADD(hour, -24, CURRENT_TIMESTAMP())
GROUP BY 1
ORDER BY 3 DESC
LIMIT 10