rakhisanjayaDISTRIBUTION OF NO OF VOTES BY CATEGORY
    Updated 2023-01-23
    with voters as (
    select
    voter,
    count(distinct proposal_id) as n_proposals
    from terra.core.fact_governance_votes
    group by voter
    )


    select
    count(distinct voter) as no_of_voters,
    CASE
    WHEN n_proposals > 0 and n_proposals <= 1 THEN 'a.0-1'
    WHEN n_proposals > 1 and n_proposals <= 10 THEN 'b.1-10'
    WHEN n_proposals > 10 and n_proposals <= 50 THEN 'c.10-50'
    WHEN n_proposals > 50 and n_proposals <= 1e2 THEN 'd.50-100'
    WHEN n_proposals > 1e2 and n_proposals <= 2 * 1e2 THEN 'e.100-200'
    WHEN n_proposals > 2 * 1e2 THEN 'f.> 200'
    END as category
    from voters
    group by category
    order by category

    Run a query to Download Data