SELECT
    s1.SALES_DATE as SAL_DATE,
    s1.SALES_NO as NO,
    s2.ITEM_CODE as ITEM_CODE,
    s2.SALES_QTY as SAL_QTY,
    s2.DELIVERED_QTY as DEL_QTY,
    CASE
     WHEN DELIVERED_QTY=0 THEN '未出荷'
     WHEN DELIVERED_QTY<>0 and SALES_QTY > DELIVERED_QTY THEN '一部出荷'
     WHEN SALES_QTY = DELIVERED_QTY THEN '出荷済'
    END as SHIP_STS
FROM
    SALES as s1
        JOIN SALES_DTL as s2
        on s1.SALES_NO = s2.SALES_NO
WHERE
    s1.SALES_DATE >= '2024-04-01'
    and s1.SALES_DATE <= '2024-04-10'
ORDER BY
    SAL_DATE desc,
    NO asc,
    ITEM_CODE asc