我的SQL知识不是很广泛，但是我认为SQl语句应该是:

My SQL knowledge is not extensive, but I think the SQl statement should be:

SELECT Student.fname, Student.lname, Subject.subject_name, Semester.semester_name, Year.year_name, MAX(Result.score) AS TopScore
FROM Result JOIN Student ON Result.student_id = Student.student_id
            JOIN Exam ON Result.Exam_id = Exam.Exam_id
            JOIN Subject ON Exam.subject_id = Subject.subject_id
            JOIN Semester ON Exam.semester_id = Semester.semester_id
            JOIN Year ON Semester.year_id = Year.year_id
GROUP BY Student.fname, Student.lname, Subject.subject_name, Semester.semester_name, Year.year_name