Mysql-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;

datediff
ex)

select DATEDIFF('2023-2-10','2023-2-5')

result:
5

대여기간의 차이를 인식할때 5일서부터 이므로 결국 datediff+1을 해줘야 정확한 차이가 된다.