select prod_id,quantity
from OrderItems
where quantity = "100" 
OR prod_id like "BNBG%"
ORDER BY prod_id