select order_num,prod_id,quantity
from OrderItems
where prod_id in('BR01','BR02','BR03') and quantity >= 100;
注意：prod_id 是字符串类型