select
    c.cust_name,
    o.order_num,
    (os.quantity * os.item_price) as OrderTotal
from Customers c
join Orders o on c.cust_id = o.cust_id 
join OrderItems os on o.order_num = os.order_num 
order by c.cust_name,OrderTotal asc