proposal_id,

count(distinct(tx_id)) as votes,

count(distinct(voter)) as voters

from cosmos.core.fact_governance_votes

where tx_succeeded

group by proposal_id