13g.     Get a list of all unique courses, and who they were taught by (by professor name), that were offered by the Finance Department (‘Finance’) in the Summer, 2001 Semester (‘2001, S2 – Summer’) ordered by course name.

 

            SELECT DISTINCT coursename, profname

            FROM course, class, professor, department

            WHERE deptname = ‘Finance’

            AND department.deptID = professor.deptID

            AND professor.profID = class.profID

            AND semester = ‘2001, S2 - Summer’

            AND class.courseID = course.courseID

            ORDER BY coursename;