proposal_id,

COUNT (DISTINCT tx_id) as n_votes,

COUNT(DISTINCT voter) as n_voters

FROM terra.core.fact_governance_votes

WHERE tx_succeeded = 'TRUE'

AND proposal_id in ('3619','3665','3794','3795','3796')

GROUP BY date,proposal_id