# SELECT cust_id, # (SELECT SUM(quantity*item_price) # FROM OrderItems # WHERE OrderItems.order_num = Orders.order_num) as total_ordered # FROM Orders # Order by total_ordered DESC SELECT o.cust_id cust_id, tb.total_ordered total_ordered FROM ( SELECT ...