count (DISTINCT TX_HASH) as TXN,

count (DISTINCT ORIGIN_FROM_ADDRESS) as Users,

sum (AMOUNT_IN_USD) as USD,

when AMOUNT_IN_USD < 50 then 'Less than 50 USD'

when AMOUNT_IN_USD BETWEEN 50 and 100 then 'Between 50 and 100 USD'

when AMOUNT_IN_USD BETWEEN 100 and 500 then 'Between 100 and 500 USD'

when AMOUNT_IN_USD BETWEEN 500 and 1000 then 'Between 500 and 1000 USD'

when AMOUNT_IN_USD BETWEEN 1000 and 5000 then 'Between 1K and 5K USD'

when AMOUNT_IN_USD BETWEEN 5000 and 10000 then 'Between 5K and 10K USD'

else 'More than 10K USD' end as Dist

FROM avalanche.core.ez_dex_swaps

GROUP BY Dist