JOINS - Multiple tables
40.2
Exercise

Joining more than 2 tables

Write a query to display the name of all the students who have a student mentor, the name of the course they are enrolled in, along with the name of the student who is their student mentor, and the course the student mentor is enrolled in.

The headers for the name of student, name of the course, name of the student mentor, and name of the course student mentor is enrolled in should be studentName, courseName, mentorName and mentorCourseName respectively.