select
  s.SALES_DATE as SAL_DATE,
  s.SALES_NO as NO,
  d.ITEM_CODE as ITEM_CODE,
  d.SALES_QTY as SAL_QTY,
  d.DELIVERED_QTY as DEL_QTY,
  case
    when DELIVERED_QTY = 0 then '未出荷'
    when SALES_QTY = DELIVERED_QTY then '出荷済'
    else '一部出荷'
  end as SHIP_STS
from SALES s
  join SALES_DTL d on s.SALES_NO = d.SALES_NO
where
  s.SALES_DATE >= '2024-04-01'
  and s.SALES_DATE <= '2024-04-10'
order by
  s.SALES_DATE desc,
  s.SALES_NO,
  d.ITEM_CODE