proposal,

min(BLOCK_TIMESTAMP) proposal_start,

count (distinct voter) as " unique voters",

count (distinct tx_id) as "Total Votes",

sum(vote_weight) as voting_weight

from

solana.core.fact_proposal_votes

where

realms_id = '3MMDxjv1SzEFQDKryT7csAvaydYtrgMAc3L9xL9CVLCg'

and SUCCEEDED = 'TRUE'

group by

1

order by

2