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 d.DELIVERED_QTY = 0 
            THEN '未出荷' 
        WHEN d.SALES_QTY > d.DELIVERED_QTY 
            THEN '一部出荷' 
        WHEN d.SALES_QTY = d.DELIVERED_QTY 
            THEN '出荷済' 
        ELSE NULL 
        END AS SHIP_STS 
FROM SALES s
JOIN SALES_DTL d
ON s.SALES_NO = d.SALES_NO
WHERE SAL_DATE BETWEEN '2024-04-01' AND '2024-04-10'
ORDER BY SAL_DATE DESC,
    NO,
    ITEM_CODE;