select cust_name, o.order_num, sum(quantity * item_price) as OrderTotal from Orders as o left join OrderItems as oi on o.order_num = oi.order_num left join Customers as ct on o.cust_id = ct.cust_id group by cust_name,order_num order by cust_name,order_num