select cust_id, (select sum(quantity * item_price) from OrderItems OI where OI.order_num = Orders.order_num) as total_ordered from Orders order by total_ordered DESC;