-- calculate the percentage of votes for each vote option (yes, no, abstain, no with veto) for each validator on each proposal during the selected time period

SELECT

--v.VALIDATOR,

v.PROPOSAL_ID,

CAST(COUNT(CASE WHEN v.VOTE = 'Yes' THEN 1 END) AS DECIMAL) / COUNT(*) * 100 AS YES_VOTES_PERCENTAGE,

CAST(COUNT(CASE WHEN v.VOTE = 'No' THEN 1 END) AS DECIMAL) / COUNT(*) * 100 AS NO_VOTES_PERCENTAGE,

CAST(COUNT(CASE WHEN v.VOTE = 'Abstain' THEN 1 END) AS DECIMAL) / COUNT(*) * 100 AS ABSTAIN_VOTES_PERCENTAGE,

CAST(COUNT(CASE WHEN v.VOTE = 'NoWithVeto' THEN 1 END) AS DECIMAL) / COUNT(*) * 100 AS NOWITHVETO_VOTES_PERCENTAGE

FROM osmosis.core.fact_governance_validator_votes v

WHERE

(v.VALIDATOR ='{{validator_1}}'

or v.VALIDATOR ='{{validator_2}}'

or v.VALIDATOR ='{{validator_3}}')

AND v.CREATED_AT >= '{{start_date}}'

AND v.CREATED_AT <= '{{end_date}}'

GROUP BY

1