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