select order_num,prod_id,quantity
from OrderItems
where (prod_id = 'BR01' or prod_id='BR02' or prod_id = 'BR03') 
and quantity >=100