SELECT cust_id,( SELECT SUM(order_total) FROM ( SELECT order_num,SUM(item_price*quantity) AS order_total FROM OrderItems GROUP BY order_num ) AS OT WHERE OT.order_num=O.order_num ) AS total_ordered FROM Ord...