select  s.SALES_DATE SAL_DATE
        ,s.SALES_NO NO
        ,d.ITEM_CODE ITEM_CODE
        ,d.SALES_QTY SAL_QTY
        ,d.DELIVERED_QTY DEL_QTY
        ,case
         when d.DELIVERED_QTY = 0 then '未出荷'
         when d.DELIVERED_QTY > 0 and d.SALES_QTY > d.DELIVERED_QTY then '一部出荷'
         when d.DELIVERED_QTY > 0 and d.SALES_QTY = d.DELIVERED_QTY then '出荷済'
         end SHIP_STS
  from  SALES s
        ,SALES_DTL d
 where  s.SALES_NO = d.SALES_NO
   and  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