题解 | 返回购买 prod_id 为 BR01 的产品的所有顾客的电子邮件（一）
返回购买 prod_id 为 BR01 的产品的所有顾客的电子邮件（一）
https://www.nowcoder.com/practice/962b16554fbf4b99a87f4d68020c5bfb
SELECT DISTINCT C.cust_email FROM Customers C JOIN Orders O ON C.cust_id = O.cust_id JOIN OrderItems OI ON O.order_num = OI.order_num WHERE OI.prod_id = 'BR01';
查看5道真题和解析