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 DELIVERED_QTY = 0 THEN '未出荷'
  WHEN DELIVERED_QTY <> 0 AND SALES_QTY > DELIVERED_QTY THEN '一部出荷'
  ELSE '出荷済'
END as SHIP_STS
from SALES as s INNER JOIN SALES_DTL as sd ON
s.SALES_NO = sd.SALES_NO 
where s.SALES_DATE between '2024-04-01' AND '2024-04-10'
order by SAL_DATE DESC, NO ASC, ITEM_CODE ASC;