MLDZMNvuser2
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
›
⌄
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
distinct PROPOSAL_TITLE,
count(distinct voter) as no_voters
from ethereum.core.ez_snapshot
where NETWORK = 'Avalanche C-Chain'
and SPACE_ID = 'hubbleexchange.eth'
and voter in (select voter from t1)
and PROPOSAL_TITLE not in ('HP028 - Validator Mining Program',
'HP026 - Onboard an Oracle Provider, Block Explorer and Node Manager',
'HP027 - Onboarding Designated Market Maker')
group by 1
order by 2 desc
Run a query to Download Data