with VOTING_POWERS as( SELECT voter, log(10, (avg(VOTING_POWER) + 1)) as amount FROM terra.gov_vote WHERE CURRENT_DATE >= dateadd(day, -30, CURRENT_DATE) AND VOTING_POWER IS NOT NULL GROUP BY voter ), ranges as (select --terra.gov_vote.voter, --VOTING_POWERS.amount count(CASE WHEN VOTING_POWERS.amount > 0 AND VOTING_POWERS.amount <= 0.58 THEN proposal_id END) AS "Bin A, .01 - 2.80 VP", count(CASE WHEN VOTING_POWERS.amount > 0.58 AND VOTING_POWERS.amount <= 1.16 THEN proposal_id END) AS "Bin B, 2.80 - 13.45 VP", count(CASE WHEN VOTING_POWERS.amount > 1.16 AND VOTING_POWERS.amount <= 1.74 THEN proposal_id END) AS "Bin C, 13.45 - 53.95 VP", count(CASE WHEN VOTING_POWERS.amount > 1.74 AND VOTING_POWERS.amount <= 2.32 THEN proposal_id END) AS "Bin D, 53.95 - 207.93 VP", count(CASE WHEN VOTING_POWERS.amount > 2.32 AND VOTING_POWERS.amount <= 2.90 THEN proposal_id END) AS "Bin E, 207.93 - 793.33 VP", count(CASE WHEN VOTING_POWERS.amount > 2.90 AND VOTING_POWERS.amount <= 3.48 THEN proposal_id END) AS "Bin F, 793.33 - 3018.95 VP", count(CASE WHEN VOTING_POWERS.amount > 3.48 AND VOTING_POWERS.amount <= 4.06 THEN proposal_id END) AS "Bin G, 3018.95 - 11480.54 VP", count(CASE WHEN VOTING_POWERS.amount > 4.06 AND VOTING_POWERS.amount <= 4.64 THEN proposal_id END) AS "Bin H, 11480.54 - 43650.58 VP", count(CASE WHEN VOTING_POWERS.amount > 4.64 AND VOTING_POWERS.amount <= 5.22 THEN proposal_id END) AS "Bin I, 43650.58 - 165957.69 VP", count(CASE WHEN VOTING_POWERS.amount > 5.22 AND VOTING_POWERS.amount <= 5.80 THEN proposal_id END) AS "Bin J, 165957.69 - 630956.34 VP", count(CASE WHEN VOTING_POWERS.amount > 5.80 AND VOTING_POWERS.amount <= 6.38 THEN proposal_id END) AS "Bin K, 630956.34 - 2398831.92 VP", count(CASE WHEN VOTING_POWERS.amount > 6.38 AND VOTING_POWERS.amount <= 6.96 THEN proposal_id END) AS "Bin L, 2398831.92 - 9120107.39 VP", count(CASE WHEN VOTING_POWERS.amount > 6.96 AND VOTING_POWERS.amount <= 7.54 THEN proposal_id END) AS "Bin M, 9120107.39 - 34673684.00 VP" FROM terra.gov_vote JOIN VOTING_POWERS ON terra.gov_vote.voter = VOTING_POWERS.voter WHERE CURRENT_DATE >= dateadd(day, -30, CURRENT_DATE) AND VOTING_POWER IS NOT NULL) select * from ranges unpivot(counts for binning_ranges in ( "Bin A, .01 - 2.80 VP", "Bin B, 2.80 - 13.45 VP", "Bin C, 13.45 - 53.95 VP", "Bin D, 53.95 - 207.93 VP", "Bin E, 207.93 - 793.33 VP", "Bin F, 793.33 - 3018.95 VP", "Bin G, 3018.95 - 11480.54 VP", "Bin H, 11480.54 - 43650.58 VP", "Bin I, 43650.58 - 165957.69 VP", "Bin J, 165957.69 - 630956.34 VP", "Bin K, 630956.34 - 2398831.92 VP", "Bin L, 2398831.92 - 9120107.39 VP", "Bin M, 9120107.39 - 34673684.00 VP" )) limit 10000

LUNA Delegation Distribution