[BETWEEN,DATE,IF,CASE] 렌트 자동차 특정날짜 대여가능 여부 구분하기

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

프로그래머스

 

IF문 사용

SELECT DISTINCT(CAR_ID), IF(CAR_ID NOT IN (SELECT CAR_ID FROM CAR_RENTAL_COMPANY_RENTAL_HISTORY AS B WHERE "2022-10-16" BETWEEN START_DATE AND END_DATE),"대여 가능", "대여중") AS AVAILABILITY
FROM CAR_RENTAL_COMPANY_RENTAL_HISTORY AS A
ORDER BY CAR_ID DESC;

SELECT DISTINCT(CAR_ID), 
CASE WHEN CAR_ID NOT IN (SELECT CAR_ID FROM CAR_RENTAL_COMPANY_RENTAL_HISTORY AS B WHERE "2022-10-16" BETWEEN START_DATE AND END_DATE) 
THEN "대여 가능"
ELSE "대여중"
END AS AVAILABILITY
FROM CAR_RENTAL_COMPANY_RENTAL_HISTORY AS A
ORDER BY CAR_ID DESC;