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)
--LIMIT 100
GROUP by 1,2