131113.md

프로그래머스 131113

"조건별로 분류하여 주문상태 출력하기"

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

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