select
  SALES.SALES_DATE as SAL_DATE
  , SALES.SALES_NO as NO
  , SALES_DTL.ITEM_CODE as ITEM_CODE
  , SALES_DTL.SALES_QTY as SAL_QTY
  , SALES_DTL.DELIVERED_QTY as DEL_QTY
  , case 
    when SALES_DTL.DELIVERED_QTY = 0 
      THEN '未出荷' 
    when SALES_DTL.SALES_QTY > SALES_DTL.DELIVERED_QTY 
      THEN '一部出荷' 
    when SALES_DTL.SALES_QTY = SALES_DTL.DELIVERED_QTY 
      THEN '出荷済' 
    END AS SHIP_STS 
from
  SALES 
  inner join SALES_DTL 
    on SALES.SALES_NO = SALES_DTL.SALES_NO 
where 
  SALES.SALES_DATE >= date('2024-04-01') 
  and SALES.SALES_DATE <= date('2024-04-10') 
  --SALES.SALES_DATE BETWEEN '2024-04-01' AND '2024-04-10'
order by
  SALES.SALES_DATE desc
  , SALES.SALES_NO asc
  , SALES_DTL.ITEM_CODE asc;