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 DELIVERED_QTY <> 0 and SALES_QTY > DELIVERED_QTY THEN '一部出荷'
        WHEN DELIVERED_QTY = SALES_QTY THEN '出荷済' end as SHIPS_STS
FROM
    SALES S
INNER JOIN SALES_DTL D
ON S.SALES_NO = D.SALES_NO
WHERE
    S.SALES_DATE BETWEEN '2024-04-01' AND '2024-04-10'
ORDER BY
    S.SALES_DATE desc,
    S.SALES_NO asc,
    D.ITEM_CODE asc
;