MLDZMNvuser3
    Updated 2023-08-09
    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