zakkisyed#2 Nouns: Voting activity
Updated 2023-04-26
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
›
⌄
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