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 two Different '

when options_count = 3 then 'Voted three Different '

when options_count = 4 then 'Voted four Different '

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