description,

concat('Proposal - ', proposal_id) as proposals,

count(distinct(tx_id)) as vote_count,

count(distinct(voter)) as voter_count

from osmosis.core.fact_governance_votes a

join osmosis.core.dim_vote_options b on a.vote_option = b.vote_id

where tx_status = 'SUCCEEDED'

and proposal_id in (337, 196, 114)

group by 1,2,3

order by 1 desc