SELECT a.VALIDATOR AS validator_a, b.VALIDATOR AS validator_b, COUNT(*) AS votes_together
FROM osmosis.core.fact_governance_validator_votes a
JOIN osmosis.core.fact_governance_validator_votes b ON a.PROPOSAL_ID = b.PROPOSAL_ID AND a.VALIDATOR < b.VALIDATOR
WHERE a.VOTE = b.VOTE
GROUP BY a.VALIDATOR, b.VALIDATOR
order by 3 desc