select O.cust_id,sum(O_n.item_price*O_n.quantity) total_ordered
from OrderItems O_n join Orders O on O_n.order_num = O.order_num
group by O.cust_id
order by total_ordered desc