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