with raw as (SELECT block_timestamp, tx_id, coalesce(address_name, program_name) as project, voter, proposal, vote_weight, CASE WHEN vote_choice = 'YES' THEN 1 ELSE 0 END as vote_choice
FROM solana.core.fact_proposal_votes fpv
LEFT JOIN (SELECT address, address_name FROM solana.core.dim_labels WHERE label LIKE '%realms%') labels ON program_name = address
WHERE governance_platform = 'realms' AND SUCCEEDED)
select project, count(distinct Voter) as n_voter from raw where project != 'realms general contract' group by 1 order by 2 desc limit 10