WITH fees AS (

SELECT

project_name,

SUM(platform_fee_usd) AS "total platform fee(usd)",

SUM(creator_fee_usd) AS "total creator fee(usd)",

SUM(total_fees_usd) AS "total fees(usd)"

FROM arbitrum.nft.ez_nft_sales

WHERE block_timestamp >= CURRENT_TIMESTAMP - INTERVAL '30 DAY'

GROUP BY project_name

SELECT

project_name,

"total platform fee(usd)",

"total creator fee(usd)",

"total fees(usd)",

FROM fees

ORDER BY "total fees(usd)" DESC

LIMIT 10;