Question: CourseId CourseCode CourseName Capacity InstructorId 5 9 9 1 MATH 1 9 8 Algebra 1 7 5 2 2 9 5 1 ENGL 3 2

CourseId CourseCode CourseName Capacity InstructorId
5991 MATH198 Algebra 1752
2951 ENGL320 American Literature 1003
4278 BIOL17 Immunology 2001
2973 BIOL40 Animal Behavior 751
1415 MATH83 Number Theory 1252
InstructorId InstructorName Rank Department
1 Abe Tran Assistant Professor Biology
2 Dan Wade Associate Professor Math
3 Aya Pena Associate Professor English
CourseInstructorComplete the following query to select all course ids with instructors not in the Biology department. The query should return 5991,2951, and 1415.SELECT
/* Type your code here */
Pick
FROM Course
WHERE InstructorId IN
(SELECTFROM InstructorWHERE!=''

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!