voter,

count(DISTINCT proposal_id) as props_voted,

label as validator_name,

'osmosis' as blockchain

FROM OSMOSIS.CORE.FACT_GOVERNANCE_VOTES v

INNER JOIN OSMOSIS.CORE.FACT_VALIDATORS l

ON v.voter = l.account_address

GROUP BY voter, label, blockchain

ORDER BY props_voted DESC