boomer77vote validator vs users
Updated 2022-05-07
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
with raw as (select block_timestamp, proposal_id, option, voter, CASE
when voter_label_subtype is null then 'user'
else voter_label_subtype end as type,case
when option = 'VOTE_OPTION_NO' then 'No'
when option = 'VOTE_OPTION_NO_WITH_VETO' then 'NoWithVeto'
when option = 'VOTE_OPTION_ABSTAIN' then 'Abstain'
when option = 'VOTE_OPTION_YES' then 'Yes'
else option end as vote_option
from terra.gov_vote)
select proposal_id, vote_option, type, count(distinct voter) as vote_count
from raw
group by 1,2,3
order by cast(proposal_id as int) asc
Run a query to Download Data