SELECT

proposal_id,

DESCRIPTION,

count(DISTINCT voter) as voters,

sum(VOTE_WEIGHT) as voting_power

FROM osmosis.core.fact_governance_votes

LEFT outer JOIN osmosis.core.dim_vote_options

ON VOTE_ID = vote_option

WHERE proposal_id in (114, 196, 337)

GROUP by 1,2