proposal_id,

description,

count(distinct(tx_id)) as n_votes

from osmosis.core.fact_governance_votes v

join osmosis.core.dim_vote_options o on v.vote_option = o.vote_id

where v.vote_option != 'VOTE_OPTION_UNSPECIFIED'

and proposal_id < 500

group by proposal_id, description