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