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
2306 MATH95 Number Theory 2003
9910 CS342 Data Structures 502
4467 MATH27 Linear Algebra 1003
5615 ENGL19 English Literature 1751
3338 CS94 Machine Learning 1252
Instructor
InstructorId InstructorName Rank Department
1 Mia Chan Professor English
2 Aya Hale Associate Professor Computer Science
3 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 CS342 and CS94.FROM Course
WHERE InstructorId =
(SELECTFROM InstructorWHERE ='');SELECT

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!