Question: Course CourseId CourseCode CourseName Capacity InstructorId 2 3 0 6 MATH 9 5 Number Theory 2 0 0 3 9 9 1 0 CS 3
Course
CourseId CourseCode CourseName Capacity InstructorId
MATH Number Theory
CS Data Structures
MATH Linear Algebra
ENGL English Literature
CS Machine Learning
Instructor
InstructorId InstructorName Rank Department
Mia Chan Professor English
Aya Hale Associate Professor Computer Science
Rob Luna 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 query to select all course codes taught by Aya Hale. The query should return CS and CSFROM Course
WHERE InstructorId
SELECTFROM InstructorWHERE ;SELECT
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
