select 
SALES_DATE as SAL_DATE,
sales.SALES_NO as NO,
ITEM_CODE,
SALES_QTY as SAL_QTY,
DELIVERED_QTY as DEL_QTY,
case 
    when DELIVERED_QTY=0 then "未出荷"
    when SALES_QTY>DELIVERED_QTY then "一部出荷"
    when SALES_QTY=DELIVERED_QTY then "出荷済"
end as SHIP_STS
from sales 
inner join sales_dtl 
on sales.sales_no=sales_dtl.sales_no 
where sales_date between '2024-04-01' and '2024-04-10' 
order by sal_date desc,no,item_code;