CASE

WHEN vote_option = 1 THEN 'YES'

WHEN vote_option = 2 THEN 'ABSTAIN'

WHEN vote_option = 3 THEN 'NO WITH VETO'

WHEN vote_option = 4 THEN 'NO'

END as vote_type,

sum(VOTE_WEIGHT) as casted_vote,

count(distinct VOTER) as voter_cnt

from osmosis.core.fact_governance_votes

where TX_STATUS='SUCCEEDED'

and proposal_id = 82

GROUP by 1