select cust_id,total_ordered from Orders join (select order_num,sum(item_price*quantity) as total_ordered from OrderItems group by order_num) as temp on Orders.order_num = temp.order_num order by total_ordered desc;