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