PROPOSAL_ID as ID,

SUM(VOTING_POWER) as overall_voting_power,

AVG(VOTING_POWER) as average_voting_power,

average_voting_power/overall_voting_power as average_total_ratio

FROM terra.gov_vote

WHERE OPTION='VOTE_OPTION_YES' AND TX_STATUS = 'SUCCEEDED'

GROUP BY 1

ORDER BY 1 DESC