1
2
3
4
5
6
7
8
-- 코드를 입력하세요
SELECT CAR_ID, 
/* ROUND(AVG(DATEDIFF(END_DATE,START_DATE)+1),1) AS AVERAGE_DURATION */
round( sum( TIMESTAMPDIFF(DAY, START_DATE, END_DATE)+1)/count(CAR_ID),1)  as AVERAGE_DURATION
from CAR_RENTAL_COMPANY_RENTAL_HISTORY
group by CAR_ID
having AVERAGE_DURATION >=7
order by 2 desc,1 desc