-- 首先去重distinct  产品数量需要大于100
select distinct order_num from OrderItems where quantity >100 order by order_num;

去重使用distinct。用法是 select distinct 字段名 。