nitsDistribution by Voting Power
    Updated 2022-03-17
    with pre_format as (
    select
    address,
    voting_power,
    CASE
    when voting_power < 1e2 then '1 - 0-100'
    when voting_power < 1e3 then '2 - 100-1k'
    when voting_power < 1e4 then '3 - 1k-10k'
    when voting_power < 1e5 then '4 - 10k-100k'
    when voting_power < 1e6 then '5 - 100k-1M'
    when voting_power >= 1e5 then '6 - 1M-1B'
    end as class
    -- row_number() over (order by balance desc) as sort,
    -- ntile(4) over (order by balance desc) as quartile
    from terra.validator_voting_power
    where block_id = (select max(block_id) from terra.validator_voting_power)

    -- and address_label != 'hashed'
    )

    select
    address,
    voting_power,
    row_number() over (order by voting_power desc) as sort
    from pre_format
    order by sort

    /*select
    class,
    count(address),
    sum(voting_power)
    from pre_format
    group by class
    order by class
    */
    /*
    Run a query to Download Data