SQL106 将两个 SELECT 语句结合起来（一）(组合查询union)

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;