SQLab — learn SQL in your browser

Average score per subject

MediumUniversityAVG40 XP

Show the average score of each subject: the subject name and the average score rounded to 1 decimal.

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.

Tables · University

facultiesFaculties6 rows

study_groupsStudy groups32 rows

studentsStudents316 rows

teachersTeachers32 rows

subjectsSubjects28 rows

gradesGrades1,631 rows