select
    SALES_DATE    as SAL_DATE
  , SALES_NO      as NO
  , ITEM_CODE     as ITEM_CODE
  , SALES_QTY     as SAL_QTY
  , DELIVERED_QTY as DEL_QTY
  , case
      when DELIVERED_QTY = 0         then '未出荷'
      when DELIVERED_QTY < SALES_QTY then '一部出荷'
      when DELIVERED_QTY = SALES_QTY then '出荷済'
      else                                'なんかおかしい'
    end as SHIP_STS
from
  SALES s
  inner join SALES_DTL d using (SALES_NO)
where
   '2024-04-01' <= SALES_DATE and SALES_DATE <= '2024-04-10'
order by
    SAL_DATE  desc
  , NO        asc
  , ITEM_CODE asc
;