Question: 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
3636 CS426 Data Structures 501
2485 ENGL36 Creative Writing 1252
8925 BUS947 Financial Accounting 1503
9824 ENGL504 American Literature 752
7187 CS985 Machine Learning 2001
Instructor
InstructorId InstructorName Rank Department
1 Rob Rios Associate Professor Computer Science
2 Ron Hale Associate Professor English
3 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 2 courses. The query should return the row containing Ava Page.
/* Type your code here */
SELECT *
FROM Instructor I
WHERE 2>
)();(SELECT
FROM Course
WHERE InstructorId =

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!