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