Updated 2023-01-18
    with total as (
    select
    nft_to_address as wallets,
    count (tx_hash) as mints
    from ethereum.core.ez_nft_mints
    where
    block_timestamp::DATE BETWEEN '2022-07-01' AND '2022-07-31'
    and event_type = 'nft_mint'
    group by wallets
    order by mints desc
    limit 10)

    select sum(mints)
    from total
    Run a query to Download Data