select 
cust_id,
(select
 SUM(item_price*quantity)
FROM OrderItems a 
WHERE a.order_num=b.order_num)total_ordered
from Orders b
ORDER BY total_ordered DESC

将聚合的字段放在select后,用where+关联条件关联即可