使用MySQL编一个表有姓名年龄性别成绩不少于50条

CREATE TABLE student ( id INT PRIMARY KEY AUTO_INCREMENT, name VARCHAR(50) NOT NULL, age INT NOT NULL, gender ENUM('male', 'female') NOT NULL, score FLOAT NOT NULL );

INSERT INTO student (name, age, gender, score) VALUES ('张三', 18, 'male', 85.5), ('李四', 19, 'male', 90.0), ('王五', 20, 'male', 78.5), ('赵六', 21, 'male', 92.5), ('钱七', 22, 'male', 87.0), ('刘八', 23, 'male', 80.5), ('孙九', 24, 'male', 95.5), ('周十', 25, 'male', 89.0), ('吴十一', 26, 'male', 86.5), ('郑十二', 27, 'male', 88.0), ('黄十三', 28, 'male', 79.5), ('朱十四', 29, 'male', 93.5), ('陈十五', 30, 'male', 81.0), ('林十六', 31, 'male', 84.5), ('卢十七', 32, 'male', 96.0), ('梁十八', 33, 'male', 91.5), ('蒋十九', 34, 'male', 83.0), ('范二十', 35, 'male', 94.5), ('彭二十一', 36, 'male', 77.5), ('曹二十二', 37, 'male', 82.5), ('肖二十三', 38, 'male', 88.5), ('田二十四', 39, 'male', 90.5), ('钟二十五', 40, 'male', 85.0), ('姚二十六', 41, 'male', 92.0), ('汪二十七', 42, 'male', 86.0), ('余二十八', 43, 'male', 89.5), ('潘二十九', 44, 'male', 91.0), ('杨三十', 45, 'male', 87.5), ('韦三十一', 46, 'male', 83.5), ('任三十二', 47, 'male', 95.0), ('贺三十三', 48, 'male', 79.0), ('秦三十四', 49, 'male', 84.0), ('尤三十五', 50, 'male', 93.0), ('许三十六', 18, 'female', 85.5), ('何三十七', 19, 'female', 90.0), ('吕三十八', 20, 'female', 78.5), ('施三十九', 21, 'female', 92.5), ('张四十', 22, 'female', 87.0), ('孔四十一', 23, 'female', 80.5), ('曾四十二', 24, 'female', 95.5), ('徐四十三', 25, 'female', 89.0), ('邓四十四', 26, 'female', 86.5), ('冯四十五', 27, 'female', 88.0), ('邹四十六', 28, 'female', 79.5), ('郝四十七', 29, 'female', 93.5), ('万四十八', 30, 'female', 81.0), ('严四十九', 31, 'female', 84.5), ('赖五十', 32, 'female', 96.0), ('倪五十一', 33, 'female', 91.5), ('夏五十二', 34, 'female', 83.0), ('舒五十三', 35, 'female', 94.5), ('莫五十四', 36, 'female', 77.5), ('雷五十五', 37, 'female', 82.5), ('黎五十六', 38, 'female', 88.5), ('贾五十七', 39, 'female', 90.5), ('江五十八', 40, 'female', 85.0), ('崔五十九', 41, 'female', 92.0), ('钟六十', 42, 'female', 86.0), ('谭六十一', 43, 'female', 89.5), ('陆六十二', 44, 'female', 91.0), ('魏六十三', 45, 'female', 87.5), ('昌六十四', 46, 'female', 83.5), ('房六十五', 47, 'female', 95.0), ('蔡六十六', 48, 'female', 79.0), ('叶六十七', 49, 'female', 84.0), ('余六十八', 50, 'female', 93.0)