Skip
Arish's avatar

170. Practice - INNER JOIN 2

Exercise: Students and Instructors

Get student names with their instructor.

Solution

sql
1SELECT s.name, c.instructor
2FROM students s
3INNER JOIN courses c ON s.course_id = c.id;