count(distinct program_name) program_count,

count(distinct realms_id) space_count,

count(distinct proposal) proposal_count,

count(distinct voter) voter_count,

count(*) vote_count

from solana.core.fact_proposal_votes a

left join solana.core.dim_labels b on a.PROGRAM_NAME = b.address

where succeeded

and governance_platform = 'realms'