ElprognerdCopy of 01 n votes and voters
    Updated 2022-11-20
    WITH validators_list AS (
    SELECT
    raw_metadata[0]['account_address']::string AS Account_Ad
    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 in ('362')
    and tx_status = 'SUCCEEDED'
    and voter not in (select Account_Address from validatorst)
    Run a query to Download Data