CourseId CourseCode CourseName Capacity InstructorId

$1210$ BUS$61$ Business Analytics $502$

$7511$ HIST$31$ American History $251$

$1908$ MATH$419$ Linear Algebra $1253$

$2867$ BUS$822$ Financial Management $2002$

$9712$ MATH$745$ Calculus $1503$

Instructor

$$ InstructorId InstructorName Rank Department

$1$ Eli Ball Assistant Professor History

$2$ Kai Rios Associate Professor Business

$3$ Ken Rice Associate Professor Math

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 each instructor's course with the lowest capacity. The query should return the rows containing Business Analytics, American History, and Linear Algebra.

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

SELECT $*$

FROM Course C

WHERE Capacity $=$

$)()$;$($SELECT

FROM Course

WHERE InstructorId