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