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

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'