realms_id,

count(distinct tx_id) as no_of_votes,

count(distinct voter) as no_of_voters,

count(distinct proposal) as no_of_proposals

from solana.core.fact_proposal_votes

where governance_platform = 'realms'

and succeeded

and block_timestamp >= '2022-01-01'

group by 1

order by 3 desc