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