select C.cust_name,O.order_num,sum(OI.quantity * OI.item_price) OrderTotal from Customers C join Orders O on C.cust_id =O.cust_id join OrderItems OI on O.order_num = OI.order_num group by C.cust_name,O.order_num order by C.cust_name asc,O.order_num asc