강의로 돌아가기
newForinux

MySQL 정답

.

작성중인 코드―solution.sql
1
2
3
4
5
6
7
8
-- 코드를 입력하세요
SELECT ORDER_ID, PRODUCT_ID, DATE_FORMAT(OUT_DATE, '%Y-%m-%d'),
    CASE
        WHEN OUT_DATE IS NULL THEN '출고미정'
        WHEN DATEDIFF(OUT_DATE, "2022-05-01") > 0 THEN '출고대기'
        ELSE '출고완료'
    END AS '출고여부'
FROM FOOD_ORDER ORDER BY ORDER_ID ASC;
0 개의 답변
답변 쓰기
This input form supports markdown syntax. Please refer to 마크다운 가이드.