SELECT

d.depositor AS user,

SUM(d.amount_usd) AS total_deposited_usd,

SUM(b.amount_usd) AS total_borrowed_usd

FROM gnosis.defi.ez_lending_deposits d

LEFT JOIN gnosis.defi.ez_lending_borrows b ON d.depositor = b.borrower

WHERE d.amount_usd IS NOT NULL

GROUP BY d.depositor

),

borrow_power AS (

SELECT

user,

total_deposited_usd,

total_borrowed_usd,

total_deposited_usd * 0.8 AS max_borrow_power_usd -- Set borrowing power based on 80% of deposits

FROM depositors

SELECT

user,

total_deposited_usd,

max_borrow_power_usd,

total_borrowed_usd,

(max_borrow_power_usd - total_borrowed_usd) AS remaining_borrow_power_usd

FROM borrow_power

WHERE remaining_borrow_power_usd > 0 -- Only show users with remaining borrowing power

ORDER BY total_deposited_usd DESC; -- Order by total deposits