SELECT
proposal_id,
--DESCRIPTION,
--count(DISTINCT voter) as voters,
--sum(VOTE_WEIGHT) as voting_power
min(block_timestamp) as first_vote,
max(block_timestamp) as last_vote
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