glass_blossomsproposal 1025
Updated 2022-05-02
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
with tb1 as (
SELECT
proposal_id,
voter,
CASE
WHEN option = 'Yes' THEN option
WHEN option = 'No' THEN option
WHEN option = 'VOTE_OPTION_YES' THEN 'Yes'
WHEN option = 'VOTE_OPTION_NO' THEN 'No'
WHEN option = 'VOTE_OPTION_ABSTAIN' THEN 'Abstain'
WHEN option = 'VOTE_OPTION_NO_WITH_VETO' THEN 'NoWithVeto'
END AS option,
CASE
WHEN proposal_id = '1025' THEN 'Beefy x Moonpot x Terra Partnership'
WHEN proposal_id = '1014' THEN 'Not So Degenerate Proposal: Road to Efficiency'
WHEN proposal_id = '971' THEN 'Greenhouse Partnership Proposal [Polygon]'
WHEN proposal_id = '929' THEN 'Relayer fee recovery (to block 7102688)'
WHEN proposal_id = '919' THEN 'ProtoFi Partnership Proposal'
END AS title,
sum(voting_power) as voting_power
FROM
terra.gov_vote
where proposal_id in ('1025', '1014', '971', '929', '919')
group by 1, 2, 3, 4
), tb2 as (
select
a.voter,
b.label,
a.option,
case when b.label is not null then 'validator'
ELSE 'retail investors' end as voters,
a.title,
avg(voting_power) as avg_vot_pow
from tb1 a left join terra.labels b
on a.voter = b.address
where voting_power > 0
Run a query to Download Data