Comprehension Passage
Instructor Table
Enrollee Table
How do you list all enrollees alongside their instructor's name?
1
SELECT EnrolleeName, InstructorName FROM Enrollee E JOIN Instructor I ON E.EnrolleeId = I.InstructorId;
2
SELECT EnrolleeName, InstructorName FROM Enrollee;
3
SELECT EnrolleeName, InstructorName FROM Enrollee, Instructor;
4
SELECT EnrolleeName, InstructorName FROM Enrollee E JOIN Instructor I ON E.InstructorId = I.InstructorId;