题解 | #确定最佳顾客的另一种方式（二）#
确定最佳顾客的另一种方式（二）
https://www.nowcoder.com/practice/b5766f970ae64ac7944f37f5b47107aa
select
cust_name,
t.total_price
from
Customers c,
Orders o,
(
select
order_num,
sum(item_price * quantity) as total_price
from
OrderItems
group by
order_num
) t
where
t.order_num = o.order_num
and o.cust_id = c.cust_id
having
t.total_price >= 1000
order by
t.total_price
#23届找工作求助阵地##软件开发薪资爆料##我的实习求职记录##你们的毕业论文什么进度了#
查看12道真题和解析