Answered step by step
Verified Expert Solution
Link Copied!

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
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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

OCA Oracle Database SQL Exam Guide Exam 1Z0-071

Authors: Steve O'Hearn

1st Edition

1259585492, 978-1259585494

More Books

Students also viewed these Databases questions

Question

1. Select the job or jobs to be analyzed.

Answered: 1 week ago