SQLab
LearnPracticeProblemsArenaLeaderboard

SQLab

University

University · Hard

Question 1

Hard40 XP

Show the 10 students with the highest average score: id, first_name, last_name and the average rounded to 1 decimal. Sort by the rounded average, highest first; break ties by id ascending.

Tables · University

facultiesFaculties6 rows
study_groupsStudy groups32 rows
studentsStudents316 rows
teachersTeachers32 rows
subjectsSubjects28 rows
gradesGrades1,631 rows

Sign in to open this section

Sign in to solve problems and play the arena. It takes less than a minute.

SQLab

Tables · University

facultiesFaculties6 rows
study_groupsStudy groups32 rows
studentsStudents316 rows
teachersTeachers32 rows
subjectsSubjects28 rows
gradesGrades1,631 rows