题解 | #确定最佳顾客的另一种方式（二）#
确定最佳顾客的另一种方式（二）
https://www.nowcoder.com/practice/b5766f970ae64ac7944f37f5b47107aa?tpId=298&tqId=2375638&ru=/exam/oj&qru=/ta/sql-teach-yourself/question-ranking&sourceUrl=%2Fexam%2Foj%3Fpage%3D1%26tab%3DSQL%25E7%25AF%2587%26topicId%3D298
select cust_name,sum(item_price*quantity) as total_price from Customers c inner join Orders o on c.cust_id=o.cust_id inner join OrderItems oi on o.order_num=oi.order_num group by cust_name having sum(item_price*quantity)>=1000 order by sum(item_price*quantity)
查看10道真题和解析
