Query editor
WITH total_stakes AS (SELECTcall_tx_signer AS staker_address,SUM(TRY_CAST(amount AS DOUBLE) / 1000000) AS total_stakedFROM jupiter_voter_solana.locked_voter_call_increaseLockedAmountGROUP BYcall_tx_signer), categorized_stakes AS (SELECTCASEWHEN total_staked <= 10THEN '0-10'WHEN total_staked <= 100THEN '10-100'WHEN total_staked <= 1000THEN '100-1k'WHEN total_staked <= 10000THEN '1k-10k'WHEN total_staked <= 12000THEN '10k-12k'WHEN total_staked <= 100000THEN '12k-100k'WHEN total_staked <= 1000000THEN '100k-1M'ELSE '>1M'END AS stake_range,COUNT(staker_address) AS address_count,SUM(total_staked) AS total_staked_in_range,CASEWHEN total_staked <= 10THEN 1WHEN total_staked <= 100THEN 2WHEN total_staked <= 1000THEN 3WHEN total_staked <= 10000THEN 4WHEN total_staked <= 12000THEN 5WHEN total_staked <= 100000THEN 6WHEN total_staked <= 1000000THEN 7ELSE 8END AS range_orderFROM total_stakesGROUP BYCASEWHEN total_staked <= 10THEN '0-10'WHEN total_staked <= 100THEN '10-100'WHEN total_staked <= 1000THEN '100-1k'WHEN total_staked <= 10000THEN '1k-10k'WHEN total_staked <= 12000THEN '10k-12k'WHEN total_staked <= 100000THEN '12k-100k'