zakkisyedTop NFT mints (count)
    Updated 2023-04-18
    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;

    Run a query to Download Data