[PGS] 자동차 평균 대여 기간 구하기

문제

예제

내 풀이

SELECT CAR_ID, ROUND(AVG(END_DATE - START_DATE) + 1, 1) AS AVERAGE_DURATION
FROM CAR_RENTAL_COMPANY_RENTAL_HISTORY
GROUP BY CAR_ID
HAVING ROUND(AVG(END_DATE - START_DATE) + 1, 1) >= 7
ORDER BY AVERAGE_DURATION DESC, CAR_ID DESC;