MLDZMNvuser3
Updated 2023-08-09
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
with t1 as (select
distinct voter
from ethereum.core.ez_snapshot
where NETWORK = 'Avalanche C-Chain'
and SPACE_ID = 'hubbleexchange.eth'
and PROPOSAL_TITLE in ('HP028 - Validator Mining Program',
'HP026 - Onboard an Oracle Provider, Block Explorer and Node Manager',
'HP027 - Onboarding Designated Market Maker')
)
select
SPACE_ID,
count(distinct voter) as "Voters"
from ethereum.core.ez_snapshot
where NETWORK = 'Avalanche C-Chain'
and voter in (select voter from t1)
and SPACE_ID != 'hubbleexchange.eth'
group by 1
Run a query to Download Data