select  dat.SALES_DATE      AS SAL_DATE
,       dat.SALES_NO        AS NO
,       dtl.ITEM_CODE       AS CODE
,       dtl.SALES_QTY       AS SAL_QTY
,       dtl.DELIVERED_QTY   AS DEL_QTY
,       CASE
            WHEN dtl.SALES_QTY = 0                  THEN '未出荷'
            WHEN dtl.SALES_QTY > dtl.DELIVERED_QTY  THEN '一部出荷'
            ELSE                                         '出荷済'
        END                 AS SHIP_STS
from SALES dat
inner join SALES_DTL dtl
   on dtl.SALES_NO = dat.SALES_NO
where dat.SALES_DATE between '2024-04-01' and '2024-04-10'
order by SAL_DATE desc, NO, CODE