untiedbearlikely-ivory copy
    Updated 2024-10-10
    SELECT
    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;

    QueryRunArchived: QueryRun has been archived