题解 | #确定哪些订单购买了 prod_id 为 BR01
确定哪些订单购买了 prod_id 为 BR01 的产品（一）
https://www.nowcoder.com/practice/b692b0174c0444fa9452aee2d082fbbb
# 先子查询 筛选 一波，范围变小了，再从该 范围里获取需求即可，子查询会多次查询 select cust_id, order_date from Orders where order_num in ( select order_num from OrderItems where prod_id = 'BR01' ) order by order_date
