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

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