CREATE TABLE order_tab (name varchar(32), create_time datetime, order_cnt int); INSERT INTO order_tab VALUES('张山','2022-06-01', 5); INSERT INTO order_tab VALUES('张山','2022-05-01', 15); INSERT INTO order_tab VALUES('张山','2022-05-06', 9); INSERT INTO order_tab VALUES('李四','2022-06-02', 4); INSERT INTO order_tab VALUES('李四','2022-01-22', 14); INSERT INTO order_tab VALUES('李四','2022-01-24', 2);