Question: CourseId CourseCode CourseName Capacity InstructorId 3 3 7 9 HIST 2 European History 1 7 5 2 2 0 2 9 MATH 3 6 1
CourseId CourseCode CourseName Capacity InstructorId
HIST European History
MATH Number Theory
BIOL Entomology
MATH Algebra
BIOL Microbiology
Instructor
InstructorId InstructorName Rank Department
Taj Hart Assistant Professor Biology
Gus Reed Associate Professor History
Ari Shah Professor Math
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.Select the rows returned by the query below.SELECT InstructorId, InstructorName, Department
FROM Instructor I
WHERE
SELECT COUNT
FROM Course
WHERE InstructorId I.InstructorId;
InstructorId InstructorName Department
Taj Hart Biology
Gus Reed History
Ari Shah Math
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
