13c.     Get a list of all COURSES (by name) Professor Hernandez (ProfID ‘456789012’) has taught and the semester in which they were taught.

 

            SELECT coursename, semester

            FROM class, course

            WHERE profID = ‘456789012’

            AND class.courseID = course.courseID;