MLDZMNvuser2
    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