select
  n.sales_date as SAL_DATE,
  n.sales_no as NO,
  d.item_code as ITEM_CODE,
  d.sales_qty as SALES_QTY,
  d.delivered_qty as DEL_QTY,
  case
    when d.delivered_qty = 0 then '未出荷'
    when d.sales_qty > d.delivered_qty then '一部出荷'
    when d.sales_qty = d.delivered_qty then '出荷済'
  end as SHIP_STS
from
  sales n
  inner join sales_dtl d on n.sales_no = d.sales_no
where
  n.sales_date between '2024-04-01' and '2024-04-10'
order by
  SAL_DATE desc,
  n.sales_no asc,
  ITEM_CODE asc;