SELECT ID,

datediff('day', CREATEDAT, CLOSEDAT) as n_days_held,

datediff('sec', CREATEDAT, CLOSEDAT) as n_Hour_held

from near.beta.github_activity

where CREATEDAT > '2021-12-31' and CREATEDAT< '2023-01-01'

)

select avg (n_days_held) as "Average time to close repo(Day)",

max (n_days_held) as "max time to close repo(Day)" ,

min (n_Hour_held) as "min time to close repo(Sec)"

from t1