#哪些订单购买 prod_id 为 BR01 的产品#

select tb.cust_id,tb.order_date from
(select cust_id,order_date from OrderItems
 inner join Orders on OrderItems.order_num=Orders.order_num
where prod_id='BR01') tb
order by tb.order_date;