13d.     Get a list of all the classIDs (ordered by semester) the Information Systems Department (DeptID ‘INSY’) has offered.

 

            SELECT classID

            FROM professor, class

            WHERE professor.deptID = ‘INSY’

            AND class.profID = professor.profID

            ORDER BY semester;