33.确定哪些订单购买了 prod_id 为 BR01 的产

select
prod_id='Br01'
from
OrderItems;

select a.cust_id,a.order_date
from Orders a , OrderItems b
where b.prod_id = 'BR01'
order by a.order_date asc;

select cust_id, order_date
from Orders
where order_num in
(select order_num
from OrderItems
where prod_id = 'BR01'
)
order by order_date

select cust_id,order_date
from OrderItems join  Orders