select

borrower_address as user,

b.aave_token as token,

datediff(

day, b.block_timestamp, r.block_timestamp

) as borrow_duration

from

flipside_prod_db.aave.borrows b,

flipside_prod_db.aave.repayments r

where

b.borrower_address = r.borrower

and b.aave_token = r.aave_token

and r.block_timestamp > b.block_timestamp

and repayed_tokens = borrowed_tokens

)

select

token,

symbol,

round(

avg(borrow_duration),

2

) as avg_borrow_duration

from

borrows_duration a

join ethereum.core.dim_contracts b on a.token = b.address

group by

token,

symbol

order by

avg_borrow_duration desc