Chapter $4$

How to retrieve data from two or more tables

Exercises

Write a SELECT statement that joins the Courses table to the Departments table and returns these columns: DepartmentName. CourseNumber, CourseDescription.

Sort the result set by DepartmentName and then by CourseNumber in ascending order.

Write a SELECT statement that joins the Instructors table to the Courses table and returns these columns: LastName, FirstName, CourseNumber. CourseDescrintion.

Return all courses for each instructor with a status of $"P"($part time$).$

Sort the result set by LastName and then by FirstName in ascending order.

Write a SELECT statement that joins the Departments, Courses, and Instructors tables. This statement should return these columns: DepartmentName, CourseDescription. FirstName, and LastName.

Use aliases for the tables, and return only those courses with three units.

Sort the result set by DepartmentName and then by Coursedescription in ascending sequence.

Write a SELECT statement that joins the Departments, Courses, StudentCourses, and Students tables. This statement should return these columns: DepartmentName CourseDescription. LastName, and FirstName.

Return all courses in the English department.

Sort the result set by CourseDescription in ascending sequence.

Write a SELECT statement that joins the Instructors and Courses tables and returns these columns: LastName, FirstName, and CourseDescription.

Return at least one row for each instructor, even if that instructor isn't teaching any courses.

Sort the result set by LastName and then by FirstName.

i$2$ Accessibility: Good to go