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;