rajsUntitled Query
    Updated 2023-01-12
    SELECT
    proposal_id,
    -- voter,
    count(*) as no_of_votes,
    count(distinct voter) as no_of_voters,
    count(*) / count(distinct voter) as avg_vote_per_voter
    from cosmos.core.fact_governance_votes
    -- where tx_succeeded
    -- and proposal_id = 38
    group by 1
    order by 4 desc

    Run a query to Download Data