题解 | #返回购买价格为 10 美元或以上产品的顾客列表#

1、表链接

select t1.cust_id
from OrderItems t
inner join Orders  t1 on t.order_num = t1.order_num
where t.item_price >=10

看到题目首先想到的是关联表，然后按条件筛选。

2、子查询

select cust_id from Orders
where order_num in(
    select order_num from OrderItems group by order_num having sum(item_price) >= 10
)