Untitled

SELECT PROFESSOR.NAME AS 'Professor Name',COURSE.NAME AS 'Course Name' FROM SCHEDULE
INNER JOIN PROFESSOR ON PROFESSOR.ID=SCHEDULE.PROFESSOR_ID
INNER JOIN COURSE ON COURSE.ID=SCHEDULE.COURSE_ID
WHERE PROFESSOR.DEPARTMENT_ID<>COURSE.DEPARTMENT_ID
GROUP BY SCHEDULE.SEMESTER,SCHEDULE.YEAR,COURSE.NAME,PROFESSOR.NAME
ORDER BY PROFESSOR.NAME,SCHEDULE.YEAR DESC