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:from='0x375883a1f801138b6f5ee953a7a11072129ac624'

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

WHEN '1000+ USDT' THEN 5 END