SELECT
    S.SALES_DATE AS SAL_DATE,
    SD.SALES_NO AS NO,
    SD.ITEM_CODE AS ITEM_CODE,
    SUM(SD.SALES_QTY) AS SAL_QTY,
    SUM(SD.DELIVERED_QTY) AS DEL_QTY,
    CASE
        WHEN SUM(SD.DELIVERED_QTY) = 0 THEN '未出荷'
        WHEN SUM(SD.DELIVERED_QTY) > 0 
        AND SUM(SD.SALES_QTY) > SUM(SD.DELIVERED_QTY) THEN '一部出荷'
        WHEN SUM(SD.SALES_QTY) = SUM(SD.DELIVERED_QTY) THEN '出荷済'
    END AS SHIP_STS
FROM
    SALES AS S
JOIN
    SALES_DTL AS SD
ON
    S.SALES_NO = SD.SALES_NO
WHERE
    S.SALES_DATE >= '2024-04-01'
    AND S.SALES_DATE <= '2024-04-10'
ORDER BY 
    SAL_DATE DESC,
    NO,
    ITEM_CODE;