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