Loading problem...
An academic analytics platform stores exam outcomes in an Enrollments table:
Each (student_id, course_id) pair appears at most once.
Task:
Return output with exactly these columns:
Sort the result by student_id in ascending order.
Supported submission environments:
Enrollments:
| 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 |[
{"student_id":1,"course_id":2,"grade":99},
{"student_id":2,"course_id":2,"grade":95},
{"student_id":3,"course_id":3,"grade":82}
]Student 2 has a tie at grade 95, so the smaller course_id (2) is chosen.
Enrollments:
| student_id | course_id | grade |
|------------|-----------|-------|
| 10 | 101 | 88 |
| 10 | 102 | 91 |
| 10 | 99 | 91 |
| 11 | 201 | 70 |[
{"student_id":10,"course_id":99,"grade":91},
{"student_id":11,"course_id":201,"grade":70}
]For student 10, grade 91 is highest and appears in two courses. Course 99 is selected because it is smaller than 102.
Enrollments:
| student_id | course_id | grade |
|------------|-----------|-------|
| 7 | 1 | 100 |
| 7 | 2 | 100 |
| 7 | 3 | 100 |
| 8 | 5 | 60 |
| 8 | 6 | 60 |[
{"student_id":7,"course_id":1,"grade":100},
{"student_id":8,"course_id":5,"grade":60}
]When all top grades are tied, the smallest course_id is selected for each student.
Constraints