-- 创建表结构
DROP TABLE IF EXISTS `group_test`;
create table group_test
(
id varchar(36) not null primary key,
name varchar(128) not null comment 'name',
count int default 0 comment 'count',
create_time timestamp default CURRENT_TIMESTAMP comment 'createTime'
) comment '分组测试';
-- 造数据
insert into group_test
values (1, 'name1', round(rand()*100), now() - interval 1 month);
insert into group_test
values (2, 'name2', round(rand()*100), now() - interval 2 month);
insert into group_test
values (3, 'name3', round(rand()*100), now() - interval 3 month);
insert into group_test
values (4, 'name4', round(rand()*100), now() - interval 4 month);
insert into group_test
values (5, 'name5', round(rand()*100), now() - interva