WITH blastswap AS (

SELECT

sender,

COUNT(DISTINCT tx_hash) AS transaction_count

FROM blast.defi.ez_dex_swaps

GROUP BY sender

SELECT

COUNT(DISTINCT sender) AS Users,

CASE

WHEN transaction_count < 5 THEN '<5'

WHEN transaction_count >= 5 AND transaction_count < 10 THEN '5-10'

WHEN transaction_count >= 10 AND transaction_count < 20 THEN '10-20'

WHEN transaction_count >= 20 AND transaction_count < 50 THEN '20-50'

WHEN transaction_count >= 50 THEN '>50'

END AS Amount_Category

FROM blastswap

GROUP BY Amount_Category

ORDER BY Amount_Category;