with t1 as (
select order_num
    from OrderItems
    where prod_id="BR01"
)

select cust_id,order_date
from t1 inner join Orders
on t1.order_num=Orders.order_num
order by order_date