SELECT
    s.SALES_DATE AS SAL_DATE,
    s.SALES_NO AS NO,
    sd.ITEM_CODE AS ITEM_CODE,
    sd.SALES_QTY AS SAL_QTY,
    sd.DELIVERED_QTY AS DEL_QTY,
    CASE 
        WHEN (sd.DELIVERED_QTY == 0) THEN '未発送'
        WHEN (sd.DELIVERED_QTY != 0 AND sd.DELIVERED_QTY == sd.SALES_QTY) THEN '出荷済'
        WHEN (sd.DELIVERED_QTY != 0 AND sd.DELIVERED_QTY < sd.SALES_QTY) THEN '一部出荷済'
    END AS 'SHIP_STS'
FROM
    SALES AS s
JOIN
    SALES_DTL AS sd
ON
    s.SALES_NO = sd.SALES_NO
ORDER BY
    SAL_DATE DESC,
    NO, ITEM_CODE ASC;