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

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 statem 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 tabl 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.