SELECT
g.PROPOSAL_ID,
g.VOTE,
COUNT(v.ADDRESS) AS num_validators
FROM
osmosis.core.fact_validators AS v
JOIN osmosis.core.fact_governance_validator_votes AS g ON v.ADDRESS = g.VALIDATOR_ADDRESS
GROUP BY
g.PROPOSAL_ID,
g.VOTE
ORDER BY
g.PROPOSAL_ID,
g.VOTE;