SELECT
historyid ,
carid ,
tochar(startdate,'YYYY-MM-DD') startdate ,
tochar(enddate ,'YYYY-MM-DD') enddate ,
(
CASE
WHEN tonumber(tochar(enddate - startdate + 1)) >= 30 THEN '장기 대여'
ELSE '단기 대여'
END
) AS RENTTYPE
FROM
CARRENTALCOMPANYRENTALHISTORY
WHERE
tochar(startdate, 'YYYY-MM') = '2022-09'
ORDER BY
historyid desc