mlhTotal count of votes for each type of voter
    Updated 2023-01-12
    (select 'non validator voter' as type,
    count (distinct tx_id) as votes,
    count (distinct voter) as voters
    from osmosis.core.fact_governance_votes
    where voter not in (select Account_Address
    from (select address as validator_address,
    label as validator,
    raw_metadata[0]['account_address']::string as Account_Address,
    raw_metadata[0]['rank']::string as Rank,
    raw_metadata[0]['uptime']['address']::string as Proposer
    from osmosis.core.dim_labels
    where label_subtype = 'validator'
    )
    ) )

    union ALL

    (select 'validator voter' as type,
    count (distinct tx_id) as votes,
    count (distinct voter) as voters
    from osmosis.core.fact_governance_votes
    where voter in (select Account_Address
    from (select address as validator_address,
    label as validator,
    raw_metadata[0]['account_address']::string as Account_Address,
    raw_metadata[0]['rank']::string as Rank,
    raw_metadata[0]['uptime']['address']::string as Proposer
    from osmosis.core.dim_labels
    where label_subtype = 'validator'
    )
    ) )
    Run a query to Download Data