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

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

프로그래머스

728x90

---

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