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

解法一：表连接 1：select cust_id from Orders,OrderItems

where Orders.order_num = OrderItems.order_num and item_price >= 10

表连接 2：select cust_id from Orders o1

inner join OrderItems o2 on o1.order_num = o2.order_num

where item_price >= 10

解法二：子连接

select cust_id from Orders

where order_num in (select order_num from OrderItems

where item_price >= 10

)