题解 | #将两个 SELECT 语句结合起来（二）#

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