cristinatintoGovernance Grind terra 1
    Updated 2023-01-23
    select concat('Proposal ',proposal_id), description,
    count (distinct tx_id) as Votes, count (distinct voter) as Voters
    from terra.core.fact_governance_votes t1 join osmosis.core.dim_vote_options t2 on t1.vote_option = t2.vote_id
    where proposal_id in ('3796', '3795', '3794', '3665', '3619')
    group by 1, 2
    order by 1 desc
    Run a query to Download Data