The StudentID column from the Students table

The sum of the course units for each student

Sort the result set in descending sequence by the total course units for each student.

Modify the solution to exercise $5$ so it only includes students who haven't graduated and who are taking more than nine units.

$7.$ Write a SELECT statement that answers this question: What is the total number of courses taught by part$-$time instructors only? Return these columns:

The instructor's last name and first name from the Instructors table in this format: Doe, John $($Note: If the instructor first name has a null value, the concatenation of the first and last name will result in a null value.$)$

The total number of courses taught by each instructor

Use the ROLLUP operator to include a row that gives the grand total.