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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
