CASE

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

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

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

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

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

WHEN total_borrowed > 100000 THEN '$100000+'

END AS borrow_range,

COUNT(DISTINCT sender_id) AS num_borrowers

FROM (

SELECT

sender_id,

SUM(amount_usd) AS total_borrowed

FROM

near.defi.ez_lending

WHERE

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

AND actions IN ('borrow')

GROUP BY

sender_id

) AS borrower_data

total_borrowed > 0

GROUP BY

borrow_range

ORDER BY

CASE

WHEN borrow_range = '$1 - 100' THEN 1

WHEN borrow_range = '$101 - 1000' THEN 2

WHEN borrow_range = '$1001 - 10000' THEN 3

WHEN borrow_range = '$10001 - 50000' THEN 4

WHEN borrow_range = '$50001 - 100000' THEN 5

WHEN borrow_range = '$100000+' THEN 6

END;