select SALES_DATE as SAL_DATE,s.SALES_NO as NO,ITEM_CODE,SALES_QTY as SAL_QTY,DELIVERED_QTY as DEL_QTY,
    case
        when DELIVERED_QTY = 0 then '未出荷'
        when DELIVERED_QTY != 0 and SALES_QTY > DELIVERED_QTY then '一部出荷'
        when DELIVERED_QTY = SALES_QTY then '出荷済'
    end as SHIP_STS
from SALES s inner join SALES_DTL sd on s.SALES_NO = sd.SALES_NO 
order by SALES_DATE desc, s.SALES_NO, ITEM_CODE