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