题解 | #确定哪些订单购买了 prod_id...#

select
    s.cust_id,
    s.order_date
from
    Orders as s
    join (
        select
            prod_id,
            order_num
        from
            OrderItems
        where
            prod_id = 'BR01'
    ) as t ON s.order_num = t.order_num
    ORDER by 
     s.order_date