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