CASE

WHEN AMOUNT_IN_USD < 10 THEN '1. Less than 10$'

WHEN AMOUNT_IN_USD < 100 THEN '2. 10$ - 100$'

WHEN AMOUNT_IN_USD < 1000 THEN '3. 100$ - 1000$'

WHEN AMOUNT_IN_USD < 10000 THEN '4. 1000$ - 10,000$'

WHEN AMOUNT_IN_USD < 100000 THEN '5. 10,000$ - 100,000$'

ELSE '6. more than 100,000$'

END as bin,

COUNT(DISTINCT tx_hash) as swap_count

FROM optimism.sushi.ez_swaps

GROUP BY 1