题解 | #检索并列出已订购产品的清单#

select order_num, prod_id, quantity
from OrderItems
where quantity >= 100 and prod_id = 'BR01'
union
select order_num, prod_id, quantity
from OrderItems
where quantity >= 100 and prod_id = 'BR02'
union
select order_num, prod_id, quantity
from OrderItems
where quantity >= 100 and prod_id = 'BR03'

select order_num, prod_id, quantity
from OrderItems
where quantity >= 100 and prod_id in ('BR01', 'BR02', 'BR03')