CHALLENGE ACTIVITY

$3\mathrm{.}4\mathrm{.}1$: Complex queries.

$544118\mathrm{.}3285590.$qx$3$zqy$7$

The table diagram below describes a university's database.The university wants to know the course names of the sections taught by instructors with rank Associate Professor whose salaries are greater than the average salary of instructors with rank Professor.The query below answers the university's question. Fill in the missing keywords.$($A$)($B$)($C$)$

Ex: Keyword

SELECT C$.$Name

FROM Course C

INNER JOIN Section S ON C$.$CourseID $=$ S$.$CourseID

INNER JOIN SectionInstructor SI ON S$.$SectionID $=$ SI$.$SectionID

INNER JOIN Instructor I ON SI$.$InstructorID $=$ I.InstructorID

WHERE I.AcademicRank $=$ 'Associate Professor' AND I.Salary $<$

$($SELECT $\_\_\_\_($A$)\_\_\_\_$

FROM $\_\_\_\_($B$)\_\_\_\_$

WHERE AcademicRank $=\text{'}\_\_\_\_($C$)\_\_\_\_\text{'})$;