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

SELECT DISTINCT CAR.CAR_ID 
FROM CAR_RENTAL_COMPANY_CAR AS CAR 
    INNER JOIN CAR_RENTAL_COMPANY_RENTAL_HISTORY AS HISTORY
        ON CAR.CAR_ID = HISTORY.CAR_ID
WHERE CAR.CAR_TYPE = '세단'
    AND HISTORY.start_date BETWEEN '2022-10-01' AND '2022-10-31'
ORDER BY CAR_ID DESC

 

https://school.programmers.co.kr/learn/courses/30/lessons/157341