with cr as (with stake as (

Select depositor_address, sum(supplied_usd) as total_staked_usd

from aave.deposits

group by depositor_address

),

borrowings as (

Select borrower, sum(DEBT_TO_COVER_AMOUNT_USD) as total_debt_usd

from aave.liquidations

group by borrower

select stake.depositor_address as cr_address, total_staked_usd, total_debt_usd, total_staked_usd/total_debt_usd as collateralization_ratio

from stake

inner join borrowings on stake.depositor_address = borrowings.borrower),

top20 as (

select borrower, sum(LIQUIDATED_AMOUNT_USD) as total_liquidated_usd

from aave.liquidations

where LIQUIDATED_AMOUNT_USD is not null

group by borrower order by total_liquidated_usd desc

limit 20

select top20.borrower as address, cr.collateralization_ratio, top20.total_liquidated_usd

from top20

inner join cr on top20.borrower = cr.cr_address