This Leetcode problem Highest Grade For Each Student LeetCode Solution is done in SQL.
List of all LeetCode Solution
![Highest Grade For Each Student LeetCode Solution](https://i0.wp.com/totheinnovation.com/wp-content/uploads/2024/02/LeetCode-Problem-Solution.png?resize=200%2C200&ssl=1)
Highest Grade For Each Student LeetCode Solution
Table of Contents
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 |
Highest Grade For Each Student LeetCode Solution 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;
Code language: SQL (Structured Query Language) (sql)