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;