Question: 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

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.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!