Professor Victoria Emmerline is set to retire immediately before spring semester. You want to generate a list of all students who are currently enrolled in any class she is teaching this spring, so you can reach out to them and let them know there will be a different professor. Assume each class she teaches could be assigned to a different professor - i.e. if Professor Emmerline was set to teach Calculus I and Calculus II, it's possible Calculus I will be assigned to Professor X and Calculus II will be assigned to Professor Y.

problem 5

Start with the same problem statement as in Problem 4, except this time generate a summary report. For each course name, list the count of the students who will need to be contacted for each format. Sort your report so it's alphabetically sorted on Course Name, then by format (online or in person). A sample output is below (your data may vary.)

problem 6

Create SQL code to answer the following query. Due to construction on campus, some final exams need to be rescheduled, and you need to make a list of students who need notification. Make a list of students' first and last names, the course department, the course number, and the professor's first and last name. We want all courses from the DAT department, and all courses from the ART department except those taught by Professor Jackson Nelson, whose studio is not affected by the construction. Order your results ascending by student last name, then Course Department and then by Course Number, and then by faculty last name.

Assume Professor Victoria Emmerline (from previous problems) has not yet retired.