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

select
    *
from
    (
        select
            prod_id,
            quantity
        from
            OrderItems
        where
            quantity = 100
        union all
        select
            prod_id,
            quantity
        from
            OrderItems
        where
            prod_id like 'BNBG%'
    ) a
order by
    prod_id asc