SELECT
    S.SALES_DATE SAL_DATE,
    S.SALES_NO NO,
    SD.ITEM_CODE ITEM_CODE,
    SD.SALES_QTY SAL_QTY,
    SD.DELIVERED_QTY DEL_QTY,
    CASE
        WHEN SD.DELIVERED_QTY = 0 THEN "未出荷"
        WHEN SD.SALES_QTY > SD.DELIVERED_QTY THEN
            "一部出荷"
        WHEN SD.SALES_QTY = SD.DELIVERED_QTY THEN
            "出荷済"
    END SHIP_STS
FROM SALES S INNER JOIN SALES_DTL SD ON S.SALES_NO = SD.SALES_NO

WHERE 1=1
    AND SALES_DATE BETWEEN "2024-04-01" AND "2024-04-10"
ORDER BY
    SAL_DATE DESC,
    NO ASC,
    ITEM_CODE ASC