date_trunc('day', block_timestamp) as date,

proposal,

count(distinct voter) as no_of_members,

count(distinct tx_id) as total_votes

from solana.core.fact_proposal_votes

where governance_platform = 'realms'

and realms_id = '{{realms_id}}'

group by 1,2

order by 1 desc