binhachonThe Road So Far, Mvmt. I: Validators - Governance distribution
    Updated 2022-03-15
    WITH TERRA_ADDRESS AS (
    SELECT
    address,
    sum(balance_usd) as wallet_balance,
    CASE WHEN WALLET_BALANCE >= 0 AND WALLET_BALANCE <= 1000 THEN 'a. 0-1k'
    WHEN WALLET_BALANCE > 1000 AND WALLET_BALANCE <= 10000 THEN 'b. 1-10k'
    WHEN WALLET_BALANCE > 10000 AND WALLET_BALANCE <= 100000 THEN 'c. 10-100k'
    WHEN WALLET_BALANCE > 100000 AND WALLET_BALANCE <= 1000000 THEN 'd. 100k to 1m'
    WHEN WALLET_BALANCE > 1000000 AND WALLET_BALANCE <= 10000000 THEN 'e. 1m to 10m'
    WHEN WALLET_BALANCE > 10000000 THEN 'f. Above 10m' ELSE NULL END AS wallet_tier
    FROM terra.daily_balances
    WHERE date in (select max(date) from terra.daily_balances)
    GROUP BY 1
    ),
    TERRA_STATION AS (
    SELECT
    voter,
    count(proposal_id) as proposal_voted
    FROM terra.gov_vote
    GROUP BY 1
    ),
    FINAL AS (
    SELECT
    address,
    voter,
    wallet_balance,
    wallet_tier,
    proposal_voted,
    CASE WHEN proposal_voted IS NULL THEN 0 ELSE proposal_voted END AS proposal_voted2,
    CASE WHEN proposal_voted IS NULL THEN 'Non-voters' WHEN proposal_voted > 0 THEN 'Voted Once' END AS proposal_voted3,
    CASE WHEN proposal_voted IS NULL THEN '1. Non-voters'
    WHEN proposal_voted = 1 THEN '2. Voted 1 Time'
    WHEN proposal_voted >= 2 AND proposal_voted <= 5 THEN '3. Voted 2 to 5 Times'
    WHEN proposal_voted > 5 AND proposal_voted <= 10 THEN '4. Voted 6 to 10 Times'
    WHEN proposal_voted > 10 AND proposal_voted <= 20 THEN '5. Voted 10 to 20 times'
    WHEN proposal_voted > 20 THEN '6. Voted 20 times or More' END AS proposal_voted4
    Run a query to Download Data