mo115Yes Votes
Updated 2022-04-27Copy Reference Fork
9
1
2
3
4
5
6
›
⌄
select PROPOSAL_ID, option, count(voter) as voters, sum(VOTING_POWER) as power,case when VOTER_LABEL_SUBTYPE = 'validator' then 'validator' else 'regular_wallets' end as VOTER_LABEL
from terra.gov_vote
where (PROPOSAL_ID='1046' or PROPOSAL_ID='1025' or PROPOSAL_ID='1014' or PROPOSAL_ID='971' or PROPOSAL_ID='929')
and OPTION = 'VOTE_OPTION_YES'
group by 1,2,5
Run a query to Download Data