mucryptoA2 Q9
Updated 2023-01-18
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
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