题解 | #检索并列出已订购产品的清单#
检索并列出已订购产品的清单
https://www.nowcoder.com/practice/674d99a46a96494d8267ae4d162ed459
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')
投递美团等公司9个岗位