voter,

count(distinct tx_id) as no_of_votes,

count(distinct proposal) as no_of_proposals,

'Realms' AS platform

FROM solana.core.fact_proposal_votes

WHERE GOVERNANCE_platform LIKE 'realms'

group by voter

limit 10