select A.SALES_DATE as SAL_DATE
    ,A.SALES_NO as NO
    ,B.ITEM_CODE as ITEM_CODE
    ,B.SALES_QTY AS SAL_QTY
    ,B.DELIVERED_QTY as SHIP_STS
    ,CASE
    WHEN B.DELIVERED_QTY = '0' THEN '未出荷'
    WHEN B.DELIVERED_QTY < B.SALES_QTY THEN '一部出荷'
    WHEN B.DELIVERED_QTY = B.SALES_QTY THEN '出荷済'
    ELSE NULL
    END AS SHIP_STS
FROM SALES AS A
INNER JOIN SALES_DTL AS B
ON A.SALES_NO = B.SALES_NO
WHERE SALES_DATE BETWEEN '2024-04-01' AND '2024-04-10'
ORDER BY A.SALES_DATE DESC
    ,A.SALES_NO ASC
    ,B.ITEM_CODE ASC