ChiefVoters By Distribution
    SELECT
    n_voters,
    count(DISTINCT realms_id) as dao_count,
    count(CASE WHEN realms_id = 'HgcYAkXFT1ENpUCjBZWc1TjAAFacUwdGZRNhTHx9cuo' then realms_id END) as Hadeswap
    FROM
    (SELECT
    realms_id,
    count(DISTINCT voter) as n_voters
    FROM
    solana.core.fact_proposal_votes
    WHERE
    block_timestamp >= CURRENT_DATE - 30
    GROUP BY
    realms_id) t1
    GROUP BY
    n_voters
    ORDER BY
    n_voters DESC


    Run a query to Download Data