proposal_id,

vote_option_text,

count(distinct(tx_id)) as n_amount_votes

from terra.core.fact_governance_votes

group by proposal_id, vote_option_text