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$'

WHEN AMOUNT_IN_USD < 1000000 THEN '6. 100,000$ - 1,000,000$'

ELSE '7. more than 1,000,000$'

END as bin,

COUNT(DISTINCT tx_hash) as swap_count

FROM ethereum.sushi.ez_swaps

WHERE block_timestamp > '2022-05-12'

GROUP BY bin