untiedbearlikely-ivory copy
Updated 2024-10-10
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
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