Question: Write a SELECT statement that returns these columns: InstructorDest The DepartmentName column from the Departments table for an instructor LastName The LastName column from the
Write a SELECT statement that returns these columns:
InstructorDest The DepartmentName column from the Departments table for an instructor
LastName
The LastName column from the Instructors table
FirstName
The FirstName column from the Instructors table
CourseDescription. The courseDescription column from the Courses table
CourseDent The DepartmentName column from the Departments table for a course
Return one row for each course that's in a different department than the department of the instructor assigned to teach that course. Hint: You will need to join the Departments table to both the Instructors table and the Courses table, which will require you to use table aliases to distinguish the two tables.
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
