Question: CourseId CourseCode CourseName Capacity InstructorId 1 8 1 5 HIST 5 8 European History 2 5 1 9 8 8 0 MATH 4 2 Calculus

CourseId CourseCode CourseName Capacity InstructorId
1815 HIST58 European History 251
9880 MATH42 Calculus 1503
3584 BIOL42 Entomology 502
9238 HIST721 American History 1001
4520 MATH83 Algebra 753
Instructor
InstructorId InstructorName Rank Department
1 Fay Baca Professor History
2 Guy Diaz Assistant Professor Biology
3 Tia Sato Professor Math
An arrow points from the Course table's InstructorId column to the Instructor table's primary key column.Enter all values returned by the query below, separated by commas.SELECT InstructorName
FROM Instructor I
WHERE EXISTS
(SELECT *
FROM Course
WHERE InstructorId = I.InstructorId
AND Capacity >=150);
Ex: 1,2,3

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!