SELECT SA.SALES_DATE "SAL_DATE", SA.SALES_NO "NO", SAD.ITEM_CODE "ITEM_CODE", SAD.SALES_QTY "SAL_QTY", SAD.DELIVERED_QTY "DEL_QTY",
    CASE WHEN SAD.DELIVERED_QTY = 0 THEN '未出荷' 
         WHEN SAD.SALES_QTY > SAD.DELIVERED_QTY THEN '一部出荷' 
         WHEN SAD.SALES_QTY = SAD.DELIVERED_QTY THEN '出荷済' 
         ELSE NULL 
         END "SHIP_STS" 
FROM SALES "SA" INNER JOIN SALES_DTL AS SAD ON SAD.SALES_NO = SA.SALES_NO 
WHERE SA.SALES_DATE BETWEEN '2024-04-01' AND '2024-04-10' 
ORDER BY SAL_DATE DESC, NO, ITEM_CODE;