CHALLENGE ACTIVITY

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

$544118\mathrm{.}3285590.$qx$3$zqy$7$

Course

$$ CourseId CourseCode CourseName Capacity InstructorId

$4564$ HIST$64$ World History $503$

$9923$ BIOL$604$ Microbiology $2001$

$6428$ HIST$4$ American History $1003$

$2967$ BIOL$361$ Animal Behavior $251$

$9638$ PHIL$354$ American Philosophy $1502$

Instructor

$$ InstructorId InstructorName Rank Department

$1$ Kim Sims Professor Biology

$2$ Val Ray Assistant Professor Philosophy

$3$ Ben Choi Professor History

An arrow points from the Course table's InstructorId column to the Instructor table's primary key column.Enter all values returned by the query below, separated by commas.SELECT InstructorName

FROM Instructor I

WHERE EXISTS

$($SELECT $*$

FROM Course

WHERE InstructorId $=$ I.InstructorId

AND Capacity $<150)$;

Ex: $1,2,3$