Skip to main content

8

sql

-- Multi-table JOIN: Get each student's class name
SELECT students.name, classes.class_name
FROM students
JOIN enrollments ON students.student_id = enrollments.student_id
JOIN classes ON enrollments.class_id = classes.class_id;

Want to learn more?

Join CodeFriends Plus membership or enroll in a course to start your journey.

sql