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 DELIVERED_QTY
		 WHEN 0 THEN '未出荷'
		 WHEN SALES_QTY THEN '出荷済'
		 ELSE '一部出荷'
		 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 SAL_DATE DESC, NO ASC, ITEM_CODE ASC