分析

关键词：where

用法：select [列名] from [表名] where 判断条件 order by ..

判断条件：where [列名] in(元素1，元素2，...)

代码

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