proposal,

min(BLOCK_TIMESTAMP) proposal_start,

count (distinct voter) as " unique voters",

count (distinct tx_id) as "Total Votes"

from

solana.core.fact_proposal_votes

where

realms_id = 'B1CxhV1khhj7n5mi5hebbivesqH9mvXr5Hfh2nD2UCh6'

and SUCCEEDED = 'TRUE'

group by

1

order by

2