The posting was so bad I got in ahury and left off the GROUP BY:
SELECT S.student_id, S.student_name, MAX(G.grade_score)
FROM Grades AS G, Students AS S
WHERE S.student_id = G.student_id
GROUP BY S.student_id, S.student_name;
You have to have the student_id in case of duplicate names.