CourseId CourseCode CourseName Capacity InstructorId

$8829$ ENGL$851$ English Literature $1001$

$6229$ HIST$318$ European History $503$

$9406$ HIST$149$ American History $753$

$6898$ BIOL$2$ Genetics $1252$

$2633$ BIOL$683$ Animal Behavior $1752$

Instructor

$$ InstructorId InstructorName Rank Department

$1$ Noa Chow Assistant Professor English

$2$ Bob Gray Professor Biology

$3$ Gil Chen Professor History

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.Complete the following correlated subquery to find courses with a capacity less than the instructor's average course capacity. The query should return the rows containing European History and Genetics.

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

SELECT $*$

FROM Course C

WHERE Capacity $<$

$)()$;$($SELECT

FROM Course

WHERE InstructorId $=$