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