select
  main.SALES_DATE as SAL_DATE
 ,main.SALES_NO as NO
 ,dtl.ITEM_CODE as ITEM_CODE
 ,dtl.SALES_QTY as SAL_QTY
 ,dtl.DELIVERED_QTY as DEL_QTY
 ,case when dtl.DELIVERED_QTY = 0 then '未出荷'
       when dtl.DELIVERED_QTY <> 0 and dtl.SALES_QTY > dtl.DELIVERED_QTY then '一部出荷'
       when dtl.SALES_QTY = dtl.DELIVERED_QTY then '出荷済'
       else null
  end as SHIP_STS
from
    SALES as main
inner join
    SALES_DTL as dtl using(SALES_NO)
where
    main.SALES_DATE between '2024-04-01' and '2024-04-10'
order by
     SALES_DATE desc
    ,SALES_NO asc
    ,ITEM_CODE asc