Instructor can view all enrolled students

SELECT lastname,firstname, title FROM student
NATURAL JOIN enrollment
as b LEFT JOIN course ON
b.cID=course.cID
WHERE b.cID in (SELECT cID
FROM courseassignment where iId=1)
order by title,lastname,firstname;