count(distinct voter) as unique_voters,

count(distinct realms_id) as unique_daos,

count(distinct tx_id) as unique_votes,

count(distinct proposal) as unique_proposal

from

solana.core.fact_proposal_votes

where

governance_platform='realms' and

succeeded = true