--CREATE OWN TABLE

- USE SIMPLE SQL

MurachCollege database is going to be used for this part. Sort the result set by DepartmentName and then by CourseNumber in ascending order. 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. 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. Return all courses in the English department. Sort the result set by DepartmentName and then by CourseDescription in ascending sequence. 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. Use the UNION operator to generate a result set consisting of five columns from the Students table: Status A calculated column that contains a value of UNDERGRAD or GRADUATED FirstName The FirstName column LastName The LastName column EnrollmentDate The EnrollmentDate column GraduationDate The GraduationDate column Sort the final result set by EnrollmentDate. Write a SELECT statement that returns these two columns: DepartmentName The DepartmentName column from the Departments table CourseID The CourseID column from the Courses table