select cust_name,order_num, quantity*item_price
as OrderTotal from OrderItems
left join Orders using(order_num)
left join Customers using(cust_id)
order by cust_name asc, order_num asc;