CASE

WHEN xmetric_volume < 500 THEN 'a Group 1 (0-500)'

WHEN xmetric_volume >= 500 AND xmetric_volume < 2000 THEN 'b Group 2 (500-2,000)'

WHEN xmetric_volume >= 2000 AND xmetric_volume < 5000 THEN 'c Group 2 (2,000-4999)'

WHEN xmetric_volume >= 5000 AND xmetric_volume < 10000 THEN 'd Group 3 (5,000-9999)'

WHEN xmetric_volume >= 10000 AND xmetric_volume < 20000 THEN 'e Group 4 (10,000-20,000)'

WHEN xmetric_volume >= 50000 AND xmetric_volume < 50000 THEN 'f Group 5 (20,000-49,999)'

else 'g Group 7 (50,000+)'

END AS UserGroup,

COUNT(*) AS UsersCount,

sum(xmetric_volume) as xmetric_balance

FROM (

SELECT

TO_ADDRESS,

sum(AMOUNT) as xmetric_volume

FROM polygon.core.ez_token_transfers

WHERE contract_address LIKE lower('0x854de1bf96dfbe69fc46f1a888d26934ad47b77f')

GROUP BY 1

) as t

GROUP BY UserGroup

ORDER BY UserGroup;