题解 | #买prod_id为BR01的所有顾客电子邮件#

select cust_email from OrderItems 
inner join Orders on OrderItems.order_num = Orders.order_num
inner join Customers on Customers.cust_id = Orders.cust_id
where prod_id ='BR01'

注意：多表连接的inner join写法