240626-(S) 조건별로 분류하여 주문상태 출력하기

 

SELECT  ORDER_ID,
        PRODUCT_ID,
        date_format(OUT_DATE,'%Y-%m-%d') as 'OUT_DATE',
        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