문제
풀이
WITH T1 AS (
SELECT CAR_ID
FROM CAR_RENTAL_COMPANY_RENTAL_HISTORY
WHERE '2022-10-16' BETWEEN START_DATE AND END_DATE)
SELECT CAR_ID,
IF(CAR_ID IN (SELECT CAR_ID FROM T1), '대여중', '대여 가능') AS AVAILABILITY
FROM CAR_RENTAL_COMPANY_RENTAL_HISTORY
GROUP BY CAR_ID
ORDER BY CAR_ID DESC
조금 까다로웠음
아니 자꾸 틀리길래 뭔가 했는데 '대여 가능'인데 '대여가능' 이라 써서 그런거였음ㅡㅡ