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;