题解 | 返回每个顾客不同订单的总金额
返回每个顾客不同订单的总金额
https://www.nowcoder.com/practice/ce313253a81c4947b20e801cd4da7894
select cust_id,
(select sum(quantity * item_price)
from OrderItems OI
where OI.order_num = Orders.order_num) as total_ordered
from Orders
order by
total_ordered DESC;
投递华为等公司8个岗位 >
