题解 | #返回每个顾客不同订单的总金额#
返回每个顾客不同订单的总金额
https://www.nowcoder.com/practice/ce313253a81c4947b20e801cd4da7894
SELECT cust_id,sum(temp1.price) as total_pricce
from Orders
JOIN (
SELECT order_num,sum(item_price * quantity) as price
From OrderItems
group by order_num
order by price desc
) As temp1 on Orders.order_num =temp1.order_num
group by Orders.cust_id
先用from 和join 锁定 查询的数据范围