CourseId CourseCode CourseName Capacity InstructorId

$7486$ PHIL$686$ Critical Thinking $1751$

$3920$ ENGL$649$ Intro to Poetry $1502$

$2676$ BUS$12$ Financial Accounting $1003$

$7349$ PHIL$872$ Formal Logic $751$

$6191$ ENGL$613$ English Composition $1252$

InstructorId InstructorName Rank Department

$1$ Tia Soto Professor Philosophy

$2$ Del Holt Assistant Professor English

$3$ Ina Hunt Professor Business

CourseInstructorComplete the following query to select all course ids with instructors not in the English department. The query should return $7486,2676,$ and $7349.$SELECT

$/*$ Type your code here $*/$

Pick

FROM Course

WHERE InstructorId IN

$($SELECTFROM InstructorWHERE!$=\text{'}\text{'})$;