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,

proposal_id

from osmosis.core.fact_governance_votes

where proposal_id > 350

and TX_STATUS = 'SUCCEEDED'

group by status, voter, proposal_id)

select

'More than Once' as change_status,

vote_change,

proposal_id,

case

when proposal_id = '362' then '362'

when proposal_id != '362' then 'Others'

end as category,

count(distinct voter) as count

from votes

where vote_change != 1

group by vote_change, proposal_id, category

union

select

'Once' as change_status,

vote_change,

proposal_id,

case