jackguyCosmos Proposals by Voters
    Updated 2023-02-18
    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