v.PROPOSAL_ID,

COUNT(DISTINCT v.VALIDATOR_ADDRESS) as num_validators,

COUNT(DISTINCT v.CREATED_AT) as num_votes,

COUNT(DISTINCT CASE WHEN v.VOTE = 'Yes' THEN v.VALIDATOR_ADDRESS ELSE NULL END) as num_yes_votes,

(COUNT(DISTINCT CASE WHEN v.VOTE = 'Yes' THEN v.VALIDATOR_ADDRESS ELSE NULL END) / COUNT(DISTINCT v.VALIDATOR_ADDRESS)) * 100 as pct_yes_votes

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 v.PROPOSAL_ID

ORDER BY v.PROPOSAL_ID ASC;