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
3379 HIST2 European History 1752
2029 MATH361 Number Theory 253
3929 BIOL195 Entomology 501
8082 MATH17 Algebra 1003
3806 BIOL103 Microbiology 1251
Instructor
InstructorId InstructorName Rank Department
1 Taj Hart Assistant Professor Biology
2 Gus Reed Associate Professor History
3 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 2<=
(SELECT COUNT(*)
FROM Course
WHERE InstructorId = I.InstructorId);
InstructorId InstructorName Department
1 Taj Hart Biology
2 Gus Reed History
3 Ari Shah Math

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!