使用mysql创建一个包含名字 年龄 学号 班级 数学成绩的表不少于50条每十人为一个班

CREATE TABLE students ( id INT AUTO_INCREMENT PRIMARY KEY, name VARCHAR(50) NOT NULL, age INT NOT NULL, student_number VARCHAR(50) NOT NULL, class_number INT NOT NULL, math_score INT NOT NULL );

INSERT INTO students (name, age, student_number, class_number, math_score) VALUES ('张三', 18, '001', 1, 80), ('李四', 19, '002', 1, 75), ('王五', 17, '003', 1, 90), ('赵六', 18, '004', 1, 85), ('钱七', 19, '005', 1, 95), ('孙八', 17, '006', 1, 80), ('周九', 18, '007', 1, 70), ('吴十', 19, '008', 1, 90), ('郑一', 17, '009', 1, 85), ('冯二', 18, '010', 1, 75), ('陈三', 18, '011', 2, 80), ('楚四', 19, '012', 2, 75), ('魏五', 17, '013', 2, 90), ('秦六', 18, '014', 2, 85), ('蒋七', 19, '015', 2, 95), ('沈八', 17, '016', 2, 80), ('韩九', 18, '017', 2, 70), ('杨十', 19, '018', 2, 90), ('朱一', 17, '019', 2, 85), ('徐二', 18, '020', 2, 75), ('马三', 18, '021', 3, 80), ('牛四', 19, '022', 3, 75), ('羊五', 17, '023', 3, 90), ('猴六', 18, '024', 3, 85), ('鸡七', 19, '025', 3, 95), ('狗八', 17, '026', 3, 80), ('猪九', 18, '027', 3, 70), ('熊十', 19, '028', 3, 90), ('猫一', 17, '029', 3, 85), ('兔二', 18, '030', 3, 75), ('鱼一', 18, '031', 4, 80), ('虾二', 19, '032', 4, 75), ('蟹三', 17, '033', 4, 90), ('鲸鱼四', 18, '034', 4, 85), ('海豚五', 19, '035', 4, 95), ('海星六', 17, '036', 4, 80), ('海马七', 18, '037', 4, 70), ('海龟八', 19, '038', 4, 90), ('海螺一', 17, '039', 4, 85), ('珊瑚二', 18, '040', 4, 75)