glass_blossomsproposal 1025
    Updated 2022-05-02
    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