Question: Generate SQL code to make a report which will do the following Generate a concatenated class name/number string, such as FIN 200 from something
Generate SQL code to make a report which will do the following Generate a concatenated class name/number string, such as "FIN 200" from something in the Finance Department where the course number is 200 Print that class name/number string in the first column of your report Print the class description (such as "Introduction to Finance") List the student's first name and then last name List the offering term and the format (online or in person) List the professor's first name and last name Sort your output ascending by the class name/number string, so "FIN 200", "FIN 120" and "ART 100" would be sorted in the following order: "ART 100", "FIN 120", "FIN 200." Within the same class, further sort your output so it's alphabetical by student last name, student first name 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.
Step by Step Solution
There are 3 Steps involved in it
Generate SQL code to make a report which will do the following Generate a concatenated class namenum... View full answer
Get step-by-step solutions from verified subject matter experts
