[프로그래머스] 조건별로 분류하여 주문상태 출력하기

문제

제출

SELECT order_id,product_id,date_format(out_date,'%Y-%m-%d') as OUT_DATE,
            (case 
            when out_date between '2022-01-01' and '2022-05-01' then '출고완료'
            when out_date between '2022-05-02' and '2023-12-31' then '출고대기'
            else '출고미정'
            end) as 출고여부
from food_order
order by order_id asc

📌 새로 배운 내용

✅ 부등호(=, >, <) 연산자를 사용하여 날짜 조회

2023-11-01 ~ 2023-11-30 까지의 날짜 조회

SELECT *
FROM emp
WHERE hiredate >= TO_DATE('2023-11-01', 'YYYY-MM-DD')
   AND hiredate <= TO_DATE('2023-11-30', 'YYYY-MM-DD')

또 다른 답

SELECT ORDER_ID, PRODUCT_ID, DATE_FORMAT(OUT_DATE, '%Y-%m-%d') AS OUT_DATE, 
    CASE
        WHEN OUT_DATE <= '2022-05-01' THEN '출고완료'
        WHEN OUT_DATE > '2022-05-01' THEN '출고대기'
        ELSE '출고미정'
    END AS '출고여부'
FROM FOOD_ORDER
ORDER BY ORDER_ID;