Last updated on January 22nd, 2025 at 11:14 pm

Here, we see the Highest Grade For Each Student LeetCode Solution. This Leetcode problem is solved using MySQL and Pandas.

List of all LeetCode Solution

Level of Question

Medium

Highest Grade For Each Student LeetCode Solution

1. Problem Statement

Column Name	Type
student_id	int
course_id	int
grade	int

(student_id, course_id) is the primary key of this table.

Write a SQL query to find the highest grade with its corresponding course for each student. In case of a tie, you should find the course with the smallest course_id. The output must be sorted by increasing student_id.

Example 1:
Input:

student_id	course_id	grade
2	2	95
2	3	95
1	1	90
1	2	99
3	1	80
3	2	75
3	3	82

Output:

student_id	course_id	grade
1	2	99
2	2	95
3	3	82

2. Code Implementation in Different Languages

2.1 Highest Grade For Each Student MySQL

select 
  student_id, 
  min(course_id) as course_id, 
  grade 
from 
  Enrollments 
where 
  (student_id, grade) in (
    select 
      student_id, 
      max(grade) 
    from 
      Enrollments 
    group by 
      student_id
  ) 
group by 
  student_id 
order by 
  student_id asc;