대여 기록이 존재하는 자동차 리스트 구하기

#from just what i had in mind to query 

SELECT DISTINCT h.CAR_ID 
FROM CAR_RENTAL_COMPANY_CAR AS c
JOIN CAR_RENTAL_COMPANY_RENTAL_HISTORY AS h
ON c.CAR_ID = h.CAR_ID 
WHERE CAR_TYPE ='세단' AND START_DATE LIKE '2022-10-%'
ORDER BY CAR_ID DESC

#USING SUBQUERY - seems to be more adequate for what the question asks 

SELECT DISTINT CAR_ID 
FROM CAR_RENTAL_COMPANY_RENTAL_HISTORY 
WHERE MONTH(START_DATE) = 10 AND CAR_ID
IN (SELECT CAR_ID FROM CAR_RENTAL_COMPANY_CAR WHERE CAR_TYPE = '세단') 
ORDER BY CAR_ID DESC