staker_volume_range,

COUNT(DISTINCT origin_from_address) AS number_of_stakers

FROM (

SELECT

origin_from_address,

SUM((DECODED_LOG:value::int) / 1e18) AS staked_amount,

CASE

WHEN SUM((DECODED_LOG:value::int) / 1e18) BETWEEN 1 AND 100 THEN '1-100'

WHEN SUM((DECODED_LOG:value::int) / 1e18) BETWEEN 101 AND 500 THEN '101-500'

WHEN SUM((DECODED_LOG:value::int) / 1e18) BETWEEN 501 AND 1000 THEN '501-1000'

WHEN SUM((DECODED_LOG:value::int) / 1e18) BETWEEN 1001 AND 5000 THEN '1001-5000'

WHEN SUM((DECODED_LOG:value::int) / 1e18) BETWEEN 5001 AND 10000 THEN '5001-10000'

WHEN SUM((DECODED_LOG:value::int) / 1e18) > 10000 THEN '10001+'

ELSE 'Other'

END AS staker_volume_range

FROM

kaia.core.ez_decoded_event_logs

WHERE

event_name = 'StakeKlay'

AND block_timestamp >= '2024-08-29'

GROUP BY

origin_from_address

) AS categorized_stakers

GROUP BY

staker_volume_range

ORDER BY

staker_volume_range;