mysql数据查询

CREATE TABLE student (
    id INT PRIMARY KEY AUTO_INCREMENT,
    createDate DATE NOT NULL,
    userName VARCHAR(255) NOT NULL,
    phone VARCHAR(20) NOT NULL,
    age INT NOT NULL,
    sex ENUM('男', '女') NOT NULL,
    introduce TEXT
);
CREATE TABLE score (
    id INT PRIMARY KEY AUTO_INCREMENT,
    scoreName VARCHAR(255) NOT NULL,
    result FLOAT NOT NULL,
    studentId INT,
    FOREIGN KEY (studentId) REFERENCES student(id) ON DELETE CASCADE
);INSERT INTO student (createDate, userName, phone, age, sex, introduce)
VALUES
  ('2023-10-01', '张三', '13800138000', 20, '男', '热爱运动，成绩优异。'),
  ('2023-10-02', '李四', '13800138001', 21, '女', '文静内敛，数学高手。'),
  ('2023-10-03', '王五', '13800138002', 19, '男', '性格开朗，乐于助人。'),
  ('2023-10-04', '赵六', '13800138003', 20, '女', '能歌善舞，多才多艺。'),
  ('2023-10-05', '孙七', '13800138004', 21, '男', '思维敏捷，编程达人。');


-- 向score表中插入10条成绩信息（每个学生2条）
INSERT INTO score (scoreName, result, studentId)
VALUES
  ('数学', 95.0, 1), ('英语', 88.0, 1), -- 张三的成绩
  ('数学', 92.0, 2), ('物理', 90.0, 2), -- 李四的成绩
  ('化学', 85.0, 3), ('生物', 91.0, 3), -- 王五的成绩
  ('英语', 89.0, 4), ('历史', 93.0, 4), -- 赵六的成绩
  ('地理', 87.0, 5), ('计算机', 94.0, 5); -- 孙七的成绩