freemartianDistribution Of Vote Changes
    Updated 2022-11-22
    with votes as (
    select
    voter,
    count(distinct tx_id) as vote_change,
    case
    when vote_option = '1' then 'Yes'
    when vote_option = '2' then 'No'
    when vote_option = '3' then 'Abstain'
    when vote_option = '4' then 'No With VETO'
    end as status
    from osmosis.core.fact_governance_votes
    where proposal_id = '362'
    and TX_STATUS = 'SUCCEEDED'
    group by status, voter)

    select
    vote_change,
    count(distinct voter) as count
    from votes
    group by vote_change