A university maintains data on professors, departments, courses, and schedules in four tables: DEPARTMENT, PROFESSOR, COURSE, and SCHEDULE. Write query for the names of all professors and the respective courses they teach. Each row of results must contain - PROFESSOR.NAME, COURSE.NAME for each course that each professor teaches now or in the past. The professor names may be printed in any order, but the results must not contain duplicate rows.
