rahofor/against
    Updated 2022-12-20
    with
    all_votes as (
    select
    voter,
    vote_option,
    voting_power,
    proposal_title
    from
    ethereum.core.ez_snapshot
    where
    space_id = 'aave.eth'
    and proposal_title = '[ARC] Gauntlet <> Aave Renewal'
    order by
    voting_power desc
    ),
    voters as (
    select
    voter,
    voting_power,
    vote_option,
    proposal_title
    from
    all_votes
    group by
    3,
    1,
    2
    )
    select
    *
    from
    voters
    Run a query to Download Data