Closed ji-0630 closed 1 year ago
SELECT distinct c.CAR_ID
from CAR_RENTAL_COMPANY_CAR c left join CAR_RENTAL_COMPANY_RENTAL_HISTORY r
on c.CAR_ID = r.CAR_ID
where c.CAR_TYPE = "세단"
and date_format(r.START_DATE, "%Y-%m") = "2022-10"
order by c.CAR_ID desc
문제 설명