strawbettyLuna comes from validators vs regular wallets
    Updated 2022-04-28

    SELECT
    PROPOSAL_ID as ID,
    SUM(VOTING_POWER) as total_voting_power,
    AVG(VOTING_POWER) as avg_voting_power,
    avg_voting_power/total_voting_power as avg_total_ratio,
    CASE WHEN
    VOTER=ANY(SELECT DELEGATOR_ADDRESS FROM terra.validator_labels) then 'validator'
    ELSE 'regular wallet'
    END as label
    FROM terra.gov_vote
    WHERE OPTION='VOTE_OPTION_YES' AND TX_STATUS = 'SUCCEEDED'
    GROUP BY 1,5
    ORDER BY 1 DESC
    Run a query to Download Data