NavidCopy of Untitled Query
    Updated 2022-11-19
    with daily_stats as (
    select
    PROPOSAL_ID,
    voter,
    count(distinct tx_id) as votes,
    avg(vote_weight) as avg_weight
    from
    osmosis.core.fact_governance_votes
    where tx_status='SUCCEEDED' and proposal_id!='362'
    group by 1,2
    )
    select
    'Other Proposals' as lbl,
    avg(votes) as avg_votes,
    avg(avg_weight) as avgweight
    from
    daily_stats
    union all
    select
    'Proposal #362' as lbl,
    count(distinct tx_id)/count(distinct voter) as avg_votes,
    avg(vote_weight) as avg_weight
    from
    osmosis.core.fact_governance_votes
    where tx_status='SUCCEEDED' and proposal_id = '362'

    Run a query to Download Data