with changes as (select VOTER,
count (distinct VOTE_OPTION) as vote,
sum(VOTE_WEIGHT)/vote as VOTE__WEIGHT
from osmosis.core.fact_governance_votes
where PROPOSAL_ID = {{proposal_id}}
group by 1)
select count (VOTER) as VOTER,
case when vote< 2 then 'not changed' else 'changed' end as position,
avg(VOTE__WEIGHT) as average_VOTE_WEIGHT
from changes
group by 2