# select order_num, sum(item * quantity) total_ordered # from OrderItems # group by order_num # order by total_ordered; select Orders.cust_id, temp.total_ordered from ( select order_num, sum(item_price * quantity) total_ordered from OrderItems group by order_num ) temp, Orders where temp.order_num =...