SELECT cust_id, total_ordered
FROM 
    (SELECT order_num, SUM(item_price * quantity) total_ordered
     FROM OrderItems
     GROUP BY order_num) i, Orders o
WHERE i.order_num = o.order_num
ORDER BY total_ordered DESC;