题解 | 将两个 SELECT 语句结合起来（一）
将两个 SELECT 语句结合起来（一）
https://www.nowcoder.com/practice/a33d5c0ebf434e00b22e2977a5aa3a90
SELECT
prod_id,
quantity
FROM
OrderItems
WHERE
quantity = 100
UNION
SELECT
prod_id,
quantity
FROM
OrderItems
WHERE
prod_id LIKE "BNBG%"
ORDER BY
prod_id;
