题解 | 返回购买 prod_id 为 BR01 的产品的所有顾客的电子邮件（二）
返回购买 prod_id 为 BR01 的产品的所有顾客的电子邮件（二）
https://www.nowcoder.com/practice/c7aa73afc41f4dfc925baebdd175c345
select C.cust_email from OrderItems as OI join Orders as O on OI.order_num = O.order_num join Customers as C on C.cust_id = O.cust_id where OI.prod_id = 'BR01';
投递字节跳动等公司7个岗位