Skip to main content

9

sql

-- Join students, enrollments, and classes using full table and column aliases
SELECT students.name AS student_name, classes.class_name AS enrolled_class
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