select *
from OrderItems
where quantity=100

union

select *
from OrderItems
where prod_id like "BNBG%"
order by prod_id;