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 SAL_QTY - DEL_QTY = 0 THEN '未出荷' WHEN SAL_QTY > DEL_QTY AND NOT '0' THEN '一部出荷' WHEN SAL_QTY = DEL_QTY THEN '出荷済') AS SHIP_STS END FROM SALES INNER JOIN SALES_DTL ON SALES.NO = SALES_DTL.NO 
WHERE SAL_DATE BETWEEN '2024-04-01 00:00:00' AND '2024-04-10 00:00:00'
ORDER BY SAL_DATE DESC, SALE.NO ASC, ITEM_CODE ASC;