DROP TABLE IF EXISTS `OrderItemsTWO`;
CREATE TABLE IF NOT EXISTS `OrderItemsTWO`(
order_num VARCHAR(255) NOT NULL COMMENT '商品订单号',
quantity INT(255) NOT NULL COMMENT '商品数量'
);
INSERT `OrderItemsTWO` VALUES ('a1',105),('a2',200),('a4',1121),('a5',10),('a7',5);
select * from OrderItemsTWO group by order_num having sum(quantity)>=100 order by order_num;