SELECT HISTORY_ID,CAR_ID,DATE_FORMAT(START_DATE,"%Y-%m-%d") as START_DATE,DATE_FORMAT(END_DATE,"%Y-%m-%d") as END_DATE,'장기 대여' as RENT_TYPE
from CAR_RENTAL_COMPANY_RENTAL_HISTORY
where START_DATE like '2022-09%'
and DATEDIFF(END_DATE,START_DATE)>=29
union
SELECT HISTORY_ID,CAR_ID,DATE_FORMAT(START_DATE,"%Y-%m-%d") as START_DATE,DATE_FORMAT(END_DATE,"%Y-%m-%d"),'단기 대여' as RENT_TYPE
from CAR_RENTAL_COMPANY_RENTAL_HISTORY
where START_DATE like '2022-09%'
and DATEDIFF(END_DATE,START_DATE)<29
order by HISTORY_ID desc
DATE_FORMAT
DATEDIFF