select
 sales.SALES_DATE SAL_DATE
,sales.SALES_NO NO
,SALES_DTL.ITEM_CODE ITEM_CODE
,SALES_DTL.SALES_QTY SAL_QTY
,SALES_DTL.DELIVERED_QTY DEL_QTY
, case 
	when SALES_DTL.DELIVERED_QTY=0 then '未出荷' 
	when SALES_DTL.DELIVERED_QTY != 0 AND (SALES_DTL.SALES_QTY-SALES_DTL.DELIVERED_QTY)>0 then '一部出荷'
	when SALES_DTL.SALES_QTY=SALES_DTL.DELIVERED_QTY then '出荷済'
end SHIP_STS
from sales
INNER JOIN SALES_DTL
ON SALES.SALES_NO = SALES_DTL.SALES_NO
where sales.SALES_DATE between '2024-01-01' AND '2024-04-10'
order by sales.SALES_DATE desc ,sales.SALES_NO , SALES_DTL.ITEM_CODE