nitsUntitled Query
    Updated 2022-11-26
    SELECT
    proposal_id,
    description,
    Concat(
    description, ' (', proposal_id, ' )'
    ) AS vote_desc,
    Count(DISTINCT voter) AS no_of_voters,
    Count(DISTINCT tx_id) AS no_of_txns,
    Sum(vote_weight) AS tot_voting_power,
    (tot_voting_power / no_of_voters) AS avg_voting_power
    FROM
    osmosis.core.fact_governance_votes
    LEFT OUTER JOIN osmosis.core.dim_vote_options ON vote_id = vote_option
    WHERE
    proposal_id = 362
    AND tx_status = 'SUCCEEDED'
    GROUP BY
    proposal_id,
    description,
    vote_desc

    Run a query to Download Data