CASE

WHEN transaction_count BETWEEN 1 AND 10 THEN 'a 1-10'

WHEN transaction_count BETWEEN 11 AND 30 THEN 'b 11-30'

WHEN transaction_count BETWEEN 31 AND 60 THEN 'c 31-60'

WHEN transaction_count BETWEEN 61 AND 100 THEN 'd 61-100'

WHEN transaction_count BETWEEN 101 AND 150 THEN 'e 101-150'

ELSE 'f 150+'

END as transaction_range,

COUNT(*) as transaction_count

FROM (

SELECT

origin_from_address AS user_address,

COUNT(DISTINCT tx_hash) as transaction_count

FROM avalanche.core.ez_token_transfers

WHERE symbol in ('USDC', 'USDT.e', 'USDC.e', 'USDT', 'BUSD', 'FRAX', 'MIM', 'DAI')

GROUP BY origin_from_address

) as users_transaction_activity

GROUP BY transaction_range

ORDER BY transaction_range;