select
    SALES.SALES_DATE as SAL_DATE,
    SALES.SALES_NO as NO,
    SALES_DTL.ITEM_CODE as ITEM_CODE,
    SALES_DTL.SALES_QTY as SAL_QTY,
    SALES_DTL.DELIVERED_QTY as DEL_QTY,
    
    CASE
        WHEN SALES_DTL.DELIVERED_QTY = 0 THEN '未出荷'
        WHEN SALES_DTL.DELIVERED_QTY = SALES_DTL.SALES_QTY THEN '出荷済'
        ELSE '一部出荷'
    END as SHIP_STS
  from SALES
  left join SALES_DTL
         on SALES.SALES_NO = SALES_DTL.SALES_NO
         
order by SAL_DATE DESC, NO ASC, ITEM_CODE ASC