Answered step by step
Verified Expert Solution
Question
1 Approved Answer
CourseId CourseCode CourseName Capacity InstructorId 3 6 3 6 CS 4 2 6 Data Structures 5 0 1 2 4 8 5 ENGL 3 6
CourseId CourseCode CourseName Capacity InstructorId
CS Data Structures
ENGL Creative Writing
BUS Financial Accounting
ENGL American Literature
CS Machine Learning
Instructor
InstructorId InstructorName Rank Department
Rob Rios Associate Professor Computer Science
Ron Hale Associate Professor English
Ava Page Professor Business
An arrow points from the Course table's InstructorId column to the Instructor table's primary key column.Note: Both tables may not be necessary to complete this level.Complete the following correlated subquery to find instructors who teach fewer than courses. The query should return the row containing Ava Page.
Type your code here
SELECT
FROM Instructor I
WHERE
;SELECT
FROM Course
WHERE InstructorId
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started