使用MySQL编写一个人员表 要求有姓名 年龄 班级 学号 数学成绩 不少于50条要求10人为一个班

CREATE TABLE person( id INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY, name VARCHAR(50) NOT NULL, age INT(11) NOT NULL, class INT(11) NOT NULL, student_id INT(11) NOT NULL, math_score INT(11) NOT NULL );

INSERT INTO person(name, age, class, student_id, math_score) VALUES ('张三', 18, 1, 101, 85), ('李四', 17, 1, 102, 78), ('王五', 19, 1, 103, 90), ('赵六', 18, 1, 104, 60), ('钱七', 17, 1, 105, 70), ('孙八', 19, 1, 106, 80), ('周九', 18, 1, 107, 68), ('吴十', 17, 1, 108, 76), ('郑一', 19, 1, 109, 88), ('冯二', 18, 1, 110, 92), ('张三1', 18, 2, 201, 85), ('李四1', 17, 2, 202, 78), ('王五1', 19, 2, 203, 90), ('赵六1', 18, 2, 204, 60), ('钱七1', 17, 2, 205, 70), ('孙八1', 19, 2, 206, 80), ('周九1', 18, 2, 207, 68), ('吴十1', 17, 2, 208, 76), ('郑一1', 19, 2, 209, 88), ('冯二1', 18, 2, 210, 92), ('张三2', 18, 3, 301, 85), ('李四2', 17, 3, 302, 78), ('王五2', 19, 3, 303, 90), ('赵六2', 18, 3, 304, 60), ('钱七2', 17, 3, 305, 70), ('孙八2', 19, 3, 306, 80), ('周九2', 18, 3, 307, 68), ('吴十2', 17, 3, 308, 76), ('郑一2', 19, 3, 309, 88), ('冯二2', 18, 3, 310, 92), ('张三3', 18, 4, 401, 85), ('李四3', 17, 4, 402, 78), ('王五3', 19, 4, 403, 90), ('赵六3', 18, 4, 404, 60), ('钱七3', 17, 4, 405, 70), ('孙八3', 19, 4, 406, 80), ('周九3', 18, 4, 407, 68), ('吴十3', 17, 4, 408, 76), ('郑一3', 19, 4, 409, 88), ('冯二3', 18, 4, 410, 92), ('张三4', 18, 5, 501, 85), ('李四4', 17, 5, 502, 78), ('王五4', 19, 5, 503, 90), ('赵六4', 18, 5, 504, 60), ('钱七4', 17, 5, 505, 70), ('孙八4', 19, 5, 506, 80), ('周九4', 18, 5, 507, 68), ('吴十4', 17, 5, 508, 76), ('郑一4', 19, 5, 509, 88), ('冯二4', 18, 5, 510, 92), ('张三5', 18, 6, 601, 85), ('李四5', 17, 6, 602, 78), ('王五5', 19, 6, 603, 90), ('赵六5', 18, 6, 604, 60), ('钱七5', 17, 6, 605, 70), ('孙八5', 19, 6, 606, 80), ('周九5', 18, 6, 607, 68), ('吴十5', 17, 6, 608, 76), ('郑一5', 19, 6, 609, 88), ('冯二5', 18, 6, 610, 92), ('张三6', 18, 7, 701, 85), ('李四6', 17, 7, 702, 78), ('王五6', 19, 7, 703, 90), ('赵六6', 18, 7, 704, 60), ('钱七6', 17, 7, 705, 70), ('孙八6', 19, 7, 706, 80), ('周九6', 18, 7, 707, 68), ('吴十6', 17, 7, 708, 76), ('郑一6', 19, 7, 709, 88), ('冯二6', 18, 7, 710, 92), ('张三7', 18, 8, 801, 85), ('李四7', 17, 8, 802, 78), ('王五7', 19, 8, 803, 90), ('赵六7', 18, 8, 804, 60), ('钱七7', 17, 8, 805, 70), ('孙八7', 19, 8, 806, 80), ('周九7', 18, 8, 807, 68), ('吴十7', 17, 8, 808, 76), ('郑一7', 19, 8, 809, 88), ('冯二7', 18, 8, 810, 92), ('张三8', 18, 9, 901, 85), ('李四8', 17, 9, 902, 78), ('王五8', 19, 9, 903, 90), ('赵六8', 18, 9, 904, 60), ('钱七8', 17, 9, 905, 70), ('孙八8', 19, 9, 906, 80), ('周九8', 18, 9, 907, 68), ('吴十8', 17, 9, 908, 76), ('郑一8', 19, 9, 909, 88), ('冯二8', 18, 9, 910, 92), ('张三9', 18, 10, 1001, 85), ('李四9', 17, 10, 1002, 78), ('王五9', 19, 10, 1003, 90), ('赵六9', 18, 10, 1004, 60), ('钱七9', 17, 10, 1005, 70), ('孙八9', 19, 10, 1006, 80), ('周九9', 18, 10, 1007, 68), ('吴十9', 17, 10, 1008, 76), ('郑一9', 19, 10, 1009, 88), ('冯二9', 18, 10, 1010, 92);

SELECT * FROM person