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