SELECT

d.depositor AS user,

SUM(d.amount_usd) AS total_deposited_usd,

COALESCE(SUM(b.amount_usd), 0) 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

SELECT

user,

total_deposited_usd,

total_borrowed_usd,

(CASE WHEN total_deposited_usd > 0 THEN total_borrowed_usd / total_deposited_usd ELSE 0 END) AS ltv_ratio

FROM collateral_borrowed

WHERE total_deposited_usd > 0

ORDER BY total_deposited_usd DESC -- Order by the total deposited amount

LIMIT 10; -- Adjust the limit as needed