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