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