"Borrowed Range",

COUNT(DISTINCT borrower) AS "Total Borrowers"

FROM (

SELECT

borrower,

SUM(amount_usd) AS "Total Borrowed Volume (USD)",

CASE

WHEN SUM(amount_usd) BETWEEN 1 AND 100 THEN '1-100'

WHEN SUM(amount_usd) BETWEEN 101 AND 500 THEN '101-500'

WHEN SUM(amount_usd) BETWEEN 501 AND 1000 THEN '501-1000'

WHEN SUM(amount_usd) BETWEEN 1001 AND 5000 THEN '1001-5000'

WHEN SUM(amount_usd) BETWEEN 5001 AND 10000 THEN '5001-10000'

ELSE '10000+'

END AS "Borrowed Range"

FROM gnosis.defi.ez_lending_borrows

WHERE amount_usd IS NOT NULL

GROUP BY borrower

) AS "Borrowers Category"

GROUP BY "Borrowed Range"

ORDER BY "Borrowed Range";