(select * 
 from OrderItems 
 where quantity = 100) 
union
(select * 
 from OrderItems 
 where prod_id like 'BNBG%')