[프로그래머스, 157341] 대여 기록이 존재하는 자동차 리스트 구하기 (mysql)

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

프로그래머스

728x90

---

SELECT car_id
FROM car_rental_company_car
WHERE car_type = '세단'
AND car_id IN (
    SELECT car_id
    FROM car_rental_company_rental_history
    WHERE start_date >= '2022-10-01' AND start_date <= '2022-10-31'
)
ORDER BY car_id DESC;