0xaimanNumber of ENS minted
Updated 2021-12-22
99
1
2
3
4
5
6
7
8
9
10
›
⌄
select case when n_ens=1 then 'Minted only 1 ENS' else 'Minted Multiple ENS' end as ens_holding,
count(tx_from_address) as n_ens_minter
from(select tx_from_address, count(event_inputs:id) as n_ens
from ethereum.events_emitted
where contract_address='0x57f1887a8bf19b14fc0df6fd9b2acc9af147ea85' and
event_inputs:id is not null
group by 1
)
group by 1
Run a query to Download Data