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

https://school.programmers.co.kr/learn/courses/30/lessons/157342

프로그래머스

 

- 나의 코드

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 AVG(DATEDIFF(END_DATE,START_DATE)+1) >= 7
order by AVERAGE_DURATION desc, CAR_ID desc;