13f. Get a list of students (by name) who took the course ‘Database
Management’ with Professor Chan (‘Chan, C.’) in the Spring, 2001 semester
(‘2001, S1 - Spring’).
SELECT studentname
FROM student, course, professor, class
WHERE coursename = ‘Database Management’
AND course.courseID = class.courseID
AND semester = ‘2001, S1 - Spring’
AND profname = ‘Chan, C.’
AND professor.ProfID = class.profID;