SQL 알고리즘 코드카타 16일차(1) 26.01.14(수)

부제:

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

 

1. 문제 링크:https://school.programmers.co.kr/learn/courses/30/lessons/157341
2. 정답 코드: 

SELECT rh.car_id
from car_rental_company_car as c
inner join car_rental_company_rental_history as rh
    on c.car_id = rh.car_id
where c.car_type = "세단"
    and rh.start_date like "%-10-%"
group by rh.car_id
order by rh.car_id desc

3. 오류 상황:
4. 시도 방법:
5. 최종 문제 해결 방법: