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

---

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  AVERAGE_DURATION >= 7
 ORDER
    BY  AVERAGE_DURATION DESC, CAR_ID DESC