Rocky_s2023-05-25 12:15 PM
    Updated 2023-05-25
    with total_mint AS (
    SELECT nft_to_address, count(*) AS total_trans FROM ethereum.core.ez_nft_mints
    WHERE block_timestamp BETWEEN '2022-07-01' AND '2022-07-30'
    GROUP BY 1
    ORDER BY 2 DESC
    LIMIT 10)

    SELECT sum(total_trans) FROM total_mint
    Run a query to Download Data