CHALLENGE

ACTIVITY

$3\mathrm{.}6\mathrm{.}1$: Subqueries.

$142928\mathrm{.}2560496q3zq{q}^7$

Jump to level $1$

Course

$\backslash$table$[[-$ Courseld,CourseCode,CourseName,Capacity,Instructorld$],[3636,$ENGL$693,$English Composition,$200,1],[3439,$HIST$152,$European History,$150,2],[1867,$ENGL$79,$Modern Literature,$25,1],[$Y$598,$BUS$375,$Financial Management,$50,3],[7849,$BUS$77,$Personal Finance,$100,3]]$

$\backslash$table$[[darr,,$Instructor,$],[-$ Instructorld,InstructorName,Rank,Department$],[\backslash$table$[[1],[2],[3]],\backslash$table$[[$Avi Rice$],[$Huy Ball$],[$Zoe Luna$]],\backslash$table$[[$Professor$],[$Associate Professor$],[$Professor$]],\backslash$table$[[$English$],[$History$],[$Business$]]]]$

Note: Both tables may not be necessary to complete this level.

Select the values returned by the query below.

SELECT CourseName

FROM Course

WHERE InstructorId IN

$($SELECT InstructorId

FROM Instructor

WHERE Department $!=$ 'Business'$)$;

$$ Modern Literature

$$ English Composition

$$ European History $$ English