SELECT ORIGIN_FROM_ADDRESS,

SUM(amount_in_usd) AS total_volume,

CASE

WHEN SUM(amount_in_usd) < 1000 THEN '$0-$1000'

WHEN SUM(amount_in_usd) BETWEEN 1000 AND 10000 THEN '$1000 - $10,000'

WHEN SUM(amount_in_usd) BETWEEN 10000 AND 100000 THEN '$10,000 - $100,000'

WHEN SUM(amount_in_usd) BETWEEN 100000 AND 1000000 THEN '$100,000 - $1,000,000'

ELSE '$1,000,000+'

END AS category

FROM optimism.core.ez_dex_swaps

WHERE PLATFORM = 'velodrome'

GROUP BY ORIGIN_FROM_ADDRESS

SELECT category, COUNT(DISTINCT ORIGIN_FROM_ADDRESS) AS user_count

FROM user_categories

GROUP BY category;