with maintable as (

select voter,

count (distinct vote_option) as options_count

from osmosis.core.fact_governance_votes

where tx_status = 'SUCCEEDED'

and proposal_id in ('362')

group by 1 having options_count > 1)

select case when options_count = 1 then 'Voted Once'

when options_count = 2 then 'Voted 2 Different Options'

when options_count = 3 then 'Voted 3 Different Options'

when options_count = 4 then 'Voted 4 Different Options'

else null end as type,

count (distinct voter) as Voters_Count

from maintable

where type is not null

group by 1

order by 2 desc