select 
    SALES_DATE as SAL_DATE
    , s.SALES_NO as NO
    , 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 null end
      as SHIP_STS
from sales s
inner join sales_dtl sd on s.SALES_NO=sd.SALES_NO
where SALES_DATE between '2024-04-01' and '2024-04-10'
order by 1 desc, 2, 3
;