题解 | #确定最佳顾客的另一种方式（二）#
确定最佳顾客的另一种方式（二）
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;
投递地平线等公司9个岗位
查看13道真题和解析