select order_num
from OrderItems
-- 顺序:where group by order by
/*
where quantity>=100
group by order_num
order by order_num;
*/
group by order_num
having sum(quantity)>=100
order by order_num;
select order_num
from OrderItems
-- 顺序:where group by order by
/*
where quantity>=100
group by order_num
order by order_num;
*/
group by order_num
having sum(quantity)>=100
order by order_num;