,avg(LOAN_AMOUNT_USD) as avg

,max(LOAN_AMOUNT_USD) as max

,min(LOAN_AMOUNT_USD) as min

,median(LOAN_AMOUNT_USD) as med

, case

--when date>='2019-01-01'and date<'2020-01-01' then '2019'

when date>='2020-01-01'and date<'2021-01-01' then '2020'

when date>='2021-01-01'and date<'2022-01-01' then '2021'

when date>='2022-01-01' then '2022' end as time_period

from ethereum.compound.ez_borrows

where date>='2020-01-01'

group by 1