자동차 평균 대여 기간 구하기

[ji-0630]

문제 설명

[ji-0630]

나의 풀이

SELECT CAR_ID, round(avg(datediff(END_DATE, START_DATE)+1), 1) as "AVERAGE_DURATION"
from CAR_RENTAL_COMPANY_RENTAL_HISTORY
group by CAR_ID
having AVERAGE_DURATION >= 7
order by AVERAGE_DURATION desc, CAR_ID desc