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