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