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