SELECT SALES_DATE AS 'SAL_DATE', SALES.SALES_NO AS 'NO', ITEM_CODE AS '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 INNER JOIN SALES_DTL ON SALES.SALES_NO = SALES_DTL.SALES_NO
WHERE SAL_DATE BETWEEN '2024-04-01' AND '2024-04-10'
ORDER BY SALES_DATE DESC, SALES.SALES_NO ASC, ITEM_CODE ASC;