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

SQL_프로그래머스_조건별로 분류하여 주문상태 출력하기 풀이 -- MYSQL SELECT ORDER_ID , PRODUCT_ID , DATE_FORMAT(OUT_DATE, '%Y-%m-%d') AS OUT_DATE , CASE WHEN OUT_DATE IS NULL THEN "출고미정" WHEN DATE_FORMAT(OUT_DATE,'%Y%m%d') > "20220501" THEN "출고대기" ELSE "출고완료" END AS '출고여부' FROM FOOD_ORDER ORDER BY ORDER_ID ASC; -- ORACLE SELECT ORDER_ID , PRODUCT_ID , TO_CHAR(OUT_DATE, 'YYYY-MM-DD') AS OUT_DATE , CASE WHEN OUT_DATE IS NULL THEN '출고미정' WHEN OUT_DATE > DATE '2022-05-01' THEN '출고대기' ELSE '출고완료' END AS 출고여부 FROM FOOD_ORDER O...

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

SQL_프로그래머스_조건별로 분류하여 주문상태 출력하기 풀이 -- MYSQL SELECT ORDER_ID , PRODUCT_ID , DATE_FORMAT(OUT_DATE, '%Y-%m-%d') AS OUT_DATE , CASE WHEN OUT_DATE IS NULL THEN "출고미정" WHEN DATE_FORMAT(OUT_DATE,'%Y%m%d') > "20220501" THEN "출고대기" ELSE "출고완료" END AS '출고여부' FROM FOOD_ORDER ORDER BY ORDER_ID ASC; -- ORACLE SELECT ORDER_ID , PRODUCT_ID , TO_CHAR(OUT_DATE, 'YYYY-MM-DD') AS OUT_DATE , CASE WHEN OUT_DATE IS NULL THEN '출고미정' WHEN OUT_DATE > DATE '2022-05-01' THEN '출고대기' ELSE '출고완료' END AS 출고여부 FROM FOOD_ORDER O

blog.naver.com/joonbread/224194609602