PROPOSAL,

REALMS_ID,

COUNT(VOTER) AS total_votes,

SUM(CASE WHEN VOTE_CHOICE = 'YES' THEN 1 ELSE 0 END) AS yes_votes,

SUM(CASE WHEN VOTE_CHOICE = 'NO' THEN 1 ELSE 0 END) AS no_votes,

SUM(CASE WHEN VOTE_CHOICE = 'ABSTAIN' THEN 1 ELSE 0 END) AS abstain_votes

FROM

gov.fact_proposal_votes

WHERE

PROGRAM_NAME = 'GovER5Lthms3bLBqWub97yVrMmEogzX7xNjdXpPPCVZw'

GROUP BY

PROPOSAL, REALMS_ID

ORDER BY

total_votes DESC

LIMIT 10;