1
2
3
4
5
6
7
-- 코드를 입력하세요

SELECT c.CAR_ID
FROM CAR_RENTAL_COMPANY_CAR c, CAR_RENTAL_COMPANY_RENTAL_HISTORY h
WHERE c.CAR_ID = h.CAR_ID AND c.CAR_TYPE='세단' AND MONTH(h.start_date) = 10
GROUP BY c.CAR_ID
ORDER BY c.CAR_ID DESC