baseswap_users as (

SELECT DISTINCT origin_from_address as user

FROM base.defi.ez_dex_swaps

WHERE platform = 'baseswap'

),

dex_users as (

SELECT origin_from_address as user,

count(DISTINCT platform) as dexes_used

FROM base.defi.ez_dex_swaps d

JOIN baseswap_users b ON d.origin_from_address = b.user

GROUP BY d.origin_from_address

SELECT COUNT(DISTINCT user) as users,

CASE WHEN dexes_used = 1 THEN '1 dex'

WHEN dexes_used = 2 THEN '2 dexes'

WHEN dexes_used = 3 THEN '3 dexes'

WHEN dexes_used > 3 AND dexes_used <= 6 THEN '4-6 dexes'

WHEN dexes_used > 6 AND dexes_used <= 10 THEN '7-10 dexes'

ELSE '10+ dexes'

END AS dex_activity

FROM dex_users

GROUP BY dex_activity