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