CASE

WHEN total_deposited BETWEEN 1 AND 100 THEN '$1 - 100'

WHEN total_deposited BETWEEN 101 AND 1000 THEN '$101 - 1000'

WHEN total_deposited BETWEEN 1001 AND 10000 THEN '$1001 - 10000'

WHEN total_deposited BETWEEN 10001 AND 50000 THEN '$10001 - 50000'

WHEN total_deposited BETWEEN 50001 AND 100000 THEN '$50001 - 100000'

WHEN total_deposited > 100000 THEN '$100000+'

ELSE 'Other'

END AS deposit_range,

COUNT(DISTINCT sender_id) AS num_depositors

FROM (

SELECT

sender_id,

SUM(amount_usd) AS total_deposited

FROM

near.defi.ez_lending

WHERE

symbol IN ('USDT', 'USDt', 'DAI', 'FRAX', 'USDT.e', 'USDC.e', 'USN')

AND actions IN ('deposit', 'deposit_to_reserve')

GROUP BY

sender_id

) AS depositor_data

GROUP BY

deposit_range

ORDER BY

CASE

WHEN deposit_range = '$1 - 100' THEN 1

WHEN deposit_range = '$101 - 1000' THEN 2

WHEN deposit_range = '$1001 - 10000' THEN 3

WHEN deposit_range = '$10001 - 50000' THEN 4

WHEN deposit_range = '$50001 - 100000' THEN 5

WHEN deposit_range = '$100000+' THEN 6

ELSE 7

END;