CASE

WHEN swap_count >= 100 THEN '100+'

WHEN swap_count >= 50 THEN '50 - 100 swaps'

WHEN swap_count >= 10 THEN '10 - 50 swaps'

WHEN swap_count > 1 THEN '1 - 10 swaps'

ELSE '1 swap'

END AS user_category,

COUNT(DISTINCT ORIGIN_FROM_ADDRESS) AS user_count

FROM (

SELECT ORIGIN_FROM_ADDRESS, COUNT(*) AS swap_count

FROM optimism.core.ez_dex_swaps

WHERE PLATFORM = 'uniswap-v3'

GROUP BY ORIGIN_FROM_ADDRESS

) AS user_swaps

GROUP BY user_category

ORDER BY user_category DESC;