WITH user_deposit AS (

SELECT

ORIGIN_FROM_ADDRESS AS user,

SUM(AMOUNT) AS total_deposit

FROM

avalanche.core.ez_token_transfers

WHERE SYMBOL ='aUSD'

AND CONTRACT_ADDRESS='0xabe7a9dfda35230ff60d1590a929ae0644c47dc1'

AND TO_ADDRESS='0x0363a3debe776de575c36f524b7877db7dd461db'

AND block_timestamp::date >= '{{Start_Date}}'

AND block_timestamp::date <= '{{End_Date}}'

GROUP BY

ORIGIN_FROM_ADDRESS

SELECT

CASE

WHEN total_deposit < 10 THEN '0-10'

WHEN total_deposit BETWEEN 11 AND 100 THEN '11-100'

WHEN total_deposit BETWEEN 101 AND 500 THEN '101-500'

WHEN total_deposit BETWEEN 501 AND 1000 THEN '501-1000'

ELSE 'Greater than 1000'

END AS range,

COUNT(user) AS user_count

FROM

user_deposit

GROUP BY

range

ORDER BY

CASE

WHEN range = '0-10' THEN 1

WHEN range = '11-100' THEN 2

WHEN range = '101-500' THEN 3

WHEN range = '501-1000' THEN 4

WHEN range = 'Greater than 1000' THEN 5