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

select
    order_num,
    prod_id,
    quantity
from
    OrderItems
where
    (
        prod_id = 'BR01'
        or prod_id = 'BR02'
        or prod_id = 'BR03'
    )
and quantity >= 100;
# in 与 or 作用相同，且 in 更简洁
# in ('BR01','BR02','BR03')