13h. Get a list of all students (by name) , the name of course they
took, who taught it (by Professor Name), and when they took it, who have taken
courses from the Management Department (‘Management’) AFTER the Fall, 2000
Semester (‘2000, S3 - Fall’) ordered by the semester in which they took the
course.
SELECT studentname, coursename, profname, semester
FROM student, course, class, professor, department
WHERE deptname = ‘Management’
AND department.deptid = professor.deptid
AND professor.profID = class.profID
AND semester > ‘2001, S3 – Fall’
AND class.studentID = student.StudentID
AND class.courseID = course.courseID;