SELECT *,

CASE

WHEN amount_in_usd IS NULL THEN amount_out_usd

ELSE amount_in_usd

END AS amount_usd

FROM sei.defi.ez_dex_swaps

WHERE platform = 'dragonswap'

),

cat AS (

SELECT swapper,

SUM(amount_usd) AS volume

FROM base

GROUP BY swapper

SELECT COUNT(DISTINCT swapper) AS swappers,

CASE

WHEN volume <= 10 THEN 'a. <= $10'

WHEN volume <= 100 THEN 'b. $10-$100'

WHEN volume <= 500 THEN 'c. $100-$500'

WHEN volume <= 1000 THEN 'd. $500-$1k'

WHEN volume <= 10000 THEN 'e. $1k-$10k'

WHEN volume <= 100000 THEN 'f. $10k-$100k'

WHEN volume <= 500000 THEN 'g. $100k-$500k'

WHEN volume <= 1000000 THEN 'h. $500k-$1m'

WHEN volume > 1000000 THEN 'i. > $1m'

END AS cat

FROM cat

GROUP BY 2

having cat is not null

ORDER BY 2 asc