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