SQLab — learn SQL in your browser

Final-year students and faculties

MediumUniversityJOIN40 XP

Show first_name, last_name of the 4th-year students and the name of the faculty they study in.

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