SELECT

ORIGIN_FROM_ADDRESS,

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

FROM avalanche.core.ez_decoded_event_logs

WHERE CONTRACT_NAME='Bitcoin'

AND DECODED_LOG:to='0x9f8519acfe48a1a4c579763324607ac9e3471736'

AND EVENT_NAME ='Transfer'

GROUP BY 1

),

deposit_ranges AS (

CASE

WHEN total_deposited < 0.001 THEN '0 - 0.001 btc'

WHEN total_deposited < 0.01 THEN '0.001 - 0.01 btc'

WHEN total_deposited < 0.1 THEN '0.01 - 0.1 btc'

WHEN total_deposited < 1 THEN '0.1 - 1 btc'

ELSE '1+ btc'

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 - 0.001 btc' THEN 1

WHEN '0.001 - 0.01 btc' THEN 2

WHEN '0.01 - 0.1 btc' THEN 3

WHEN '0.1 - 1 btc' THEN 4

WHEN '1+ btc' THEN 5 END