WITH user_deposits AS (

SELECT

ORIGIN_FROM_ADDRESS,

SUM(DECODED_LOG:value/POW(10,6)) AS total_deposited

FROM avalanche.core.ez_decoded_event_logs

WHERE CONTRACT_NAME='TetherToken'

AND DECODED_LOG:to='0xb91e5ae18f1c8f8d457d6a6b0317dad425932c89'

AND EVENT_NAME ='Transfer'

GROUP BY 1

),

deposit_ranges AS (

CASE

WHEN total_deposited < 1 THEN '0 - 1 USDT'

WHEN total_deposited < 10 THEN '1 - 10 USDT'

WHEN total_deposited < 100 THEN '10 - 100 USDT'

WHEN total_deposited < 1000 THEN '100 - 1000 USDT'

ELSE '1000+ USDT'

END AS deposit_range,

COUNT(*) AS user_count

FROM user_deposits

GROUP BY 1

SELECT

deposit_range,

user_count,

user_count * 100.0 / SUM(user_count) OVER () AS percentage

FROM deposit_ranges

ORDER BY

CASE deposit_range

WHEN '0 - 1 USDT' THEN 1

WHEN '1 - 10 USDT' THEN 2

WHEN '10 - 100 USDT' THEN 3

WHEN '100 - 1000 USDT' THEN 4