Question

1. Scheduling Errors A university maintains data on professors, departments, courses, and schedules in four tables: DEPARTMENT, PROFESSOR, COURSE, and SCHEDULE. Write a query to print the names of professors with the names of the courses they teach (or have taught) outside of their department. Each row in the results must be distinct (i.e., a professor teaching the same course over multiple semesters should only appear once), but the results can be in any order. Output should contain two columns: PROFESSOR.NAME, COURSE.NAME. Schema PROFESSOR Name Type Description ID Integer A professor's ID in the inclusive range [1, 1000]. This is a primary key. NAME String A professor's name. This field contains between 1 and 100 characters (inclusive).

          1. Scheduling Errors
A university maintains data on professors, departments, courses, and schedules in four
tables: DEPARTMENT, PROFESSOR, COURSE, and SCHEDULE.
Write a query to print the names of professors with the names of the courses they teach (or
have taught) outside of their department. Each row in the results must be distinct (i.e., a
professor teaching the same course over multiple semesters should only appear once), but
the results can be in any order. Output should contain two columns: PROFESSOR.NAME,
COURSE.NAME.
Schema
PROFESSOR
Name	Type	Description
ID	Integer	A professor's ID
in the inclusive
range [1, 1000].
This is a primary
key.
NAME	String	A professor's
name. This field
contains
between 1 and
100 characters
(inclusive).

1. Scheduling Errors
A university maintains data on professors, departments, courses, and schedules in four
tables: DEPARTMENT, PROFESSOR, COURSE, and SCHEDULE.
Write a query to print the names of professors with the names of the courses they teach (or
have taught) outside of their department. Each row in the results must be distinct (i.e., a
professor teaching the same course over multiple semesters should only appear once), but
the results can be in any order. Output should contain two columns: PROFESSOR.NAME,
COURSE.NAME.
Schema
PROFESSOR
Name Type Description
ID Integer A professor's ID
in the inclusive
range [1, 1000].
This is a primary
key.
NAME String A professor's
name. This field
contains
between 1 and
100 characters
(inclusive).

Added by Sara M.

Question

Please give Ace some feedback