过滤条件:①BR01、BR02 或BR03 的订单 ②订购了数量至少100 个 select order_num, prod_id, quantity from OrderItems where prod_id in ('BR01','BR02','BR03') and quantity >= 100;