Closed ji-0630 closed 1 year ago
SELECT ORDER_ID, PRODUCT_ID, date_format(OUT_DATE, "%Y-%m-%d"),
(case when date_format(OUT_DATE, "%Y-%m-%d") > "2022-05-01" then "출고대기"
when date_format(OUT_DATE, "%Y-%m-%d") <= "2022-05-01" then "출고완료"
else "출고미정"
end) as "출고여부"
from FOOD_ORDER
order by ORDER_ID
문제 설명