SELECT

CASE

WHEN total_unstaked < 1 THEN '< 1 AAVE'

WHEN total_unstaked >= 1 AND total_unstaked < 10 THEN '1-10 AAVE'

WHEN total_unstaked >= 10 AND total_unstaked < 100 THEN '10-100 AAVE'

WHEN total_unstaked >= 100 AND total_unstaked < 1000 THEN '100-1,000 AAVE'

WHEN total_unstaked >= 1000 AND total_unstaked < 10000 THEN '1,000-10,000 AAVE'

ELSE '10,000+ AAVE'

END AS unstake_category,

COUNT(DISTINCT FROM_ADDRESS) AS num_stakers

FROM (

SELECT

SUM(amount) as total_unstaked,

FROM_ADDRESS

FROM ethereum.core.ez_token_transfers

WHERE BLOCK_TIMESTAMP >= CURRENT_DATE - {{past_days}}

AND CONTRACT_ADDRESS = '0x4da27a545c0c5b758a6ba100e3a049001de870f5'

AND TO_ADDRESS = '0x0000000000000000000000000000000000000000'

GROUP BY FROM_ADDRESS

) AS subquery

GROUP BY unstake_category

SELECT *

FROM unstakers_categories