distinct voter,

sum(VOTE_WEIGHT) as "voting power"

FROM solana.core.fact_proposal_votes

where governance_platform = 'realms'

group by 1

order by 2 DESC

limit 10