题解 | #确定最佳顾客的另一种方式（二）#
确定最佳顾客的另一种方式（二）
https://www.nowcoder.com/practice/b5766f970ae64ac7944f37f5b47107aa
select cust_name,total_price
from Customers c
join Orders o
on c.cust_id = o.cust_id
join
(
select oi.order_num, sum(item_price*quantity) as total_price
from OrderItems oi
group by oi.order_num
having total_price>=1000
) as oi_new
on oi_new.order_num = o.order_num
order by total_price;
三奇智元机器人科技有限公司公司福利 94人发布