CASE

WHEN AMOUNT_IN_USD > 0 AND AMOUNT_IN_USD < 1 THEN '[0 - $1]'

WHEN AMOUNT_IN_USD >= 1 AND AMOUNT_IN_USD < 10 THEN '[$1 - $10]'

WHEN AMOUNT_IN_USD >= 10 AND AMOUNT_IN_USD < 100 THEN '[$10 - $100]'

WHEN AMOUNT_IN_USD >= 100 AND AMOUNT_IN_USD < 1000 THEN '[$100 - $1,000]'

WHEN AMOUNT_IN_USD >= 1000 AND AMOUNT_IN_USD < 10000 THEN '[$1,000 - $10,000]'

WHEN AMOUNT_IN_USD >= 10000 AND AMOUNT_IN_USD < 100000 THEN '[$10,000 - $100,000]'

ELSE '[above $100,000]'

END AS swap_size_range,

COUNT(*) AS swap_count

FROM bsc.defi.ez_dex_swaps

WHERE 1=1

AND BLOCK_TIMESTAMP >= '2024-01-01'

AND PLATFORM LIKE '%pancakeswap%'

AND EVENT_NAME = 'Swap'

GROUP BY swap_size_range

ORDER BY swap_size_range;