MLDZMNCog10
    Updated 2023-01-20
    with tb1 as (select
    raw_metadata[0]:"account_address" as validators
    from osmosis.core.dim_labels
    where label_subtype ilike 'validator')
    select
    voter,
    count (distinct tx_id) as no_votes
    from osmosis.core.fact_governance_votes
    where TX_SUCCEEDED = 'TRUE'
    and voter not in (select validators from tb1)
    group by 1
    order by 2 DESC
    limit 10
    Run a query to Download Data