자동차 대여 기록에서 대여중 / 대여 가능 여부 구분하기

SELECT CAR_ID,
    CASE
        WHEN START_DATE <= '2022-10-16' AND END_DATE >= '2022-10-16' THEN '대여중'
        ELSE '대여 가능'
    END AS AVAILABILITY
FROM 
(
    SELECT CAR_ID,
        COALESCE(MAX(START_DATE), '1900-01-01') AS START_DATE,
        COALESCE(MAX(END_DATE), '1900-01-01') AS END_DATE
    FROM CAR_RENTAL_COMPANY_RENTAL_HISTORY
    WHERE START_DATE <= '2022-10-16'
    GROUP BY CAR_ID
)AS filtered
ORDER BY CAR_ID DESC