1
2
3
4
5
6
7
8
9
-- 코드를 입력하세요
SELECT HISTORY_ID, CAR_ID,
       TO_CHAR(START_DATE,'RRRR-MM-DD') AS "START_DATE", 
       TO_CHAR(END_DATE,'RRRR-MM-DD') AS "END_DATE",
        CASE WHEN END_DATE - START_DATE +1 >= 30 THEN '장기 대여'
        ELSE '단기 대여' END AS "RENT_TYPE"
FROM CAR_RENTAL_COMPANY_RENTAL_HISTORY
WHERE TO_CHAR(START_DATE,'RRRR-MM') = '2022-09'
ORDER BY 1 DESC