select u.order_num from(select order_num, sum(quantity) as num from OrderItems group by order_num having num >= 100) u; select distinct order_num from OrderItems where quantity>=100;

select u.order_num from(select order_num, sum(quantity) as num from OrderItems group by order_num having num >= 100) u; select distinct order_num from OrderItems where quantity>=100;