select cust_name, b.order_num, sum(quantity*item_price) as OrderTotal
from Customers a
join Orders b on a.cust_id=b.cust_id
join OrderItems c on b.order_num=c.order_num
group by cust_name, b.order_num
order by cust_name, b.order_num