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