cypherGoverning the Cosmos - avg votes per proposal
    Updated 2023-01-12
    with terra_votes as (select
    proposal_id,
    count(distinct(tx_id)) as n_amount_votes
    from terra.core.fact_governance_votes
    group by proposal_id),

    terra_avg as (select
    round(avg(n_amount_votes),1) as avg_votes,
    median(n_amount_votes) as median_votes,
    'terra' as chain
    from terra_votes),

    cosmos_votes as (select
    proposal_id,
    count(distinct(tx_id)) as n_amount_votes
    from cosmos.core.fact_governance_votes
    group by proposal_id
    ),

    cosmos_avg as (select
    round(avg(n_amount_votes),1) as avg_votes,
    median(n_amount_votes) as median_votes,
    'cosmos' as chain
    from cosmos_votes
    ),

    osmosis_votes as (select
    proposal_id,
    count(distinct(tx_id)) as n_votes
    from osmosis.core.fact_governance_votes v
    where v.vote_option != 'VOTE_OPTION_UNSPECIFIED'
    group by proposal_id),

    osmosis_avg as (select
    round(avg(n_votes),1) as avg_votes,
    median(n_votes) as median_votes,
    Run a query to Download Data