select cust_id,sum(item_price*quantity) total_ordered from OrderItems,Orders where OrderItems.order_num = Orders.order_num GROUP BY cust_id order by total_ordered desc