jackguyCosmos Proposals by Voters
Updated 2023-02-18Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
SELECT
proposal_id,
min(block_timestamp) as first_vote,
count(DISTINCT case when description LIKE 'YES' THEN voter END) / (count(DISTINCT case when description LIKE 'NO' THEN voter END) + count(DISTINCT case when description LIKE 'NO WITH VETO' THEN voter END)) as yes_to_no_voter_ratio,
count(DISTINCT case when description LIKE 'YES' THEN voter END) as yes_voters,
count(DISTINCT case when description LIKE 'NO' THEN voter END) as no_voters,
count(DISTINCT case when description LIKE 'ABSTAIN' THEN voter END) as ABSTAIN_voters,
count(DISTINCT case when description LIKE 'NO WITH VETO' THEN voter END) as NO_WITH_VETO_voters
FROM cosmos.core.fact_governance_votes
LEFT outer JOIN cosmos.core.dim_vote_options
on cosmos.core.fact_governance_votes.vote_option = cosmos.core.dim_vote_options.vote_option
GROUP BY 1
order by 2 desc
Run a query to Download Data