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

select
    *
from
    (select
        prod_id,
        quantity
    from
        OrderItems
    where
        quantity = 100

    union 

    select
        prod_id,
        quantity
    from
        OrderItems
    where 
        prod_id like "BNBG%") t
order by 
    t.prod_id