WITH

votes AS (

SELECT

VALIDATOR,

COUNT(*) AS num_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

VALIDATOR

),

changed_votes AS (

SELECT

VALIDATOR,

COUNT(*) AS num_changed_votes

FROM

osmosis.core.fact_governance_validator_votes v

WHERE updated_at <> created_at

and

(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

VALIDATOR

),

changed_vote_ratio AS (