proposal_id,

description,

count(distinct(tx_id)) as n_amount_votes

from cosmos.core.fact_governance_votes

join cosmos.core.dim_vote_options using (vote_option)

group by proposal_id, description