mo115Other Osmosis Governance - Changes in votes
    Updated 2022-11-24
    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