SELECT
project_name,
SUM(nft_count) AS total_mints,
SUM(amount) AS revenue_eth,
SUM(amount_usd) AS revenue_usd
FROM
ETHEREUM.core.ez_nft_mints
WHERE
YEAR(block_timestamp) = 2023
and project_name is not null
and amount is not null
and amount_usd is not NULL
GROUP BY
project_name
ORDER BY
total_mints DESC
LIMIT 10;