zakkisyed#2 Nouns: Voting activity
    Updated 2023-04-26
    select
    event_inputs:proposalId::number as proposal_id,
    sum(event_inputs:votes::string) as no_of_votes,
    case when event_inputs:support::string = '1' then 'yes'
    when event_inputs:support::string = '2' then 'abstain'
    else 'no'
    end as voted_as
    -- event_inputs:votes::string as no_of_votes
    from ethereum.core.fact_event_logs
    where contract_address=lower('0x6f3E6272A167e8AcCb32072d08E0957F9c79223d')
    and event_name = 'VoteCast'
    group by 1,3
    order by 1 asc

    Run a query to Download Data