-- 방법 1 -- 카티션과 WHERE SELECT DISTINCT T1.CAR_ID FROM CAR_RENTAL_COMPANY_CAR T1, CAR_RENTAL_COMPANY_RENTAL_HISTORY T2 WHERE T1.CAR_ID = T2.CAR_ID AND T1.CAR_TYPE = '세단' AND T2.START_DATE LIKE '%-10-%' ORDER BY T1.CAR_ID DESC -- 방법2 -- JOIN과 ON을 사용 SELECT DISTINCT T1.CAR_ID FROM CAR_RENTAL_COMPANY_CAR T1 JOIN CAR_RENTAL_COMPANY_RENTAL_HISTORY T2 ON T1.CAR_ID = T2.CAR_ID WHERE T1.CAR_TYPE = '세단' AN..
