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.)
 Write a SELECT statement that returns these columns: InstructorDest The DepartmentName

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 Databases Questions!