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