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;