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

• ROUND+AVG +TIMESTAMPDIFF
  • Having은 변경된 속성을 접근 가능하다.

SELECT CAR_ID, ROUND(AVG(TIMESTAMPDIFF(DAY, START_DATE, END_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 ;