코딩테스트 수련일지/프로그래머스 MySQL

프로그래머스 | 자동차 평균 대여 기간 구하기

youngzzang 2023. 3. 22. 10:59
SELECT CAR_ID, ROUND(SUM(DATEDIFF(END_DATE, START_DATE) +1)/COUNT(*), 1)
AS AVERAGE_DURATION FROM CAR_RENTAL_COMPANY_RENTAL_HISTORY
GROUP BY CAR_ID
HAVING AVERAGE_DURATION > 6
ORDER BY AVERAGE_DURATION DESC, CAR_ID DESC;