case

when AMOUNT_IN_USD < 100 then 'Tier 1: Less than $100'

when AMOUNT_IN_USD >= 100 and AMOUNT_IN_USD < 1000 then 'Tier 2: $100-1K'

when AMOUNT_IN_USD >= 1000 and AMOUNT_IN_USD < 10000 then 'Tier 3: $1K-10K'

when AMOUNT_IN_USD >= 10000 and AMOUNT_IN_USD < 100000 then 'Tier 4: $10K-100K'

when AMOUNT_IN_USD >= 100000 and AMOUNT_IN_USD < 1000000 then 'Tier 5: $100K-1M'

when AMOUNT_IN_USD >= 1000000 then 'Tier 6: More than $1M'

end as status,

count(distinct SENDER) as "# Users"

from ethereum.core.ez_dex_swaps

where BLOCK_TIMESTAMP >= '2022-11-08'

and BLOCK_TIMESTAMP < '2022-11-17'

and AMOUNT_IN_USD > 0

and AMOUNT_IN_USD < 1e10

and AMOUNT_IN_USD is not null

group by 1

order by 1