题解 | #返回购买 BR01 的所有顾客的电子邮件(二)#
返回购买 prod_id 为 BR01 的产品的所有顾客的电子邮件(二)
https://www.nowcoder.com/practice/c7aa73afc41f4dfc925baebdd175c345
select cust_email from Orders as o inner join OrderItems as oi on o.order_num = oi.order_num inner join Customers as c on o.cust_id = c.cust_id where oi.prod_id = "BR01"