题解 | #确定最佳顾客的另一种方式（二）#
确定最佳顾客的另一种方式（二）
http://www.nowcoder.com/practice/b5766f970ae64ac7944f37f5b47107aa
select Customers.cust_name,e.total_price from Orders,Customers,((select order_num,sum(item_price*quantity) total_price from OrderItems group by order_num having total_price>=1000
)) e
where e.order_num=Orders.order_num&&Orders.cust_id=Customers.cust_id order by e.total_price;
查看5道真题和解析
阿里巴巴稳定性 77人发布
投递阿里巴巴等公司10个岗位