nitsValidator vs Regular
    Updated 2022-11-24
    with validatorst as (
    select address as validator_address,
    label as validator_name,
    raw_metadata[0]['account_address'] as Account_Address,
    raw_metadata[0]['rank'] as Rank,
    raw_metadata[0]['uptime']['address'] as Proposer
    from osmosis.core.dim_labels
    where label_subtype = 'validator')

    select 'Regular Voters' as type,
    count (distinct tx_id) as Votes_Count
    from osmosis.core.fact_governance_votes
    where proposal_id = '362'
    and tx_status = 'SUCCEEDED'
    and voter not in (select Account_Address from validatorst)

    union ALL

    select 'Voter Validators' as type,
    count (distinct tx_id) as Votes_Count
    from osmosis.core.fact_governance_votes
    where proposal_id = '362'
    and tx_status = 'SUCCEEDED'
    and voter in (select Account_Address from validatorst)




    Run a query to Download Data