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