SELECT cust_id,total_ordered FROM Orders AS o JOIN ( SELECT order_num,SUM(item_price * quantity) AS total_ordered FROM OrderItems GROUP BY order_num)AS a ON o.order_num=a.order_num ORDER BY total_ordered DESC