题解 | 子查询应该这么写#返回每个顾客不同订单的总金额#
返回每个顾客不同订单的总金额
http://www.nowcoder.com/practice/ce313253a81c4947b20e801cd4da7894
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+关联条件关联即可
滴滴公司福利 1026人发布
