count(distinct voter) as no_of_members,

count(distinct tx_id) as total_votes,

count(distinct proposal) as no_of_proposals,

min(block_timestamp::date) as date_of_creation,

datediff(day, min(block_timestamp::date), CURRENT_DATE) as days_since_creation

from solana.core.fact_proposal_votes

where governance_platform = 'realms'

and realms_id = '{{realms_id}}'