题解 |
返回购买 prod_id 为 BR01 的产品的所有顾客的电子邮件（一）
https://www.nowcoder.com/practice/962b16554fbf4b99a87f4d68020c5bfb
SELECT cust_email FROM Customers WHERE cust_id IN ( SELECT cust_id FROM Orders WHERE order_num IN( SELECT order_num FROM OrderItems WHERE prod_id LIKE 'BR01' ) );
投递腾讯等公司10个岗位