SELECT supplier

, SUM(supplied_base_asset_usd) AS deposits

FROM compound.deposits

GROUP BY 1

HAVING SUM(supplied_base_asset_usd) > 0

)

, borrows AS (

SELECT borrower

, SUM(loan_amount_usd) AS loans

FROM compound.borrows

GROUP BY 1

)

, ratio as (SELECT supplier

, deposits

, loans

, ROUND(loans*1.0/deposits,5) AS pct_borrowed

FROM deposits d JOIN borrows b ON d.supplier = b.borrower

)

SELECT APPROX_PERCENTILE(pct_borrowed,0.5) AS median_pct_borrowed FROM ratio