SELECT
  prod_id,
  quantity
FROM
  OrderItems
WHERE
  quantity = 100
UNION ALL
SELECT
  prod_id,
  quantity
FROM
  OrderItems
WHERE
  prod_id LIKE 'BNBG%'
ORDER BY
  prod_id;