Question: Using a single SQL query and the material learned from chapters 1 - 5, I want you to provide me with the following set of
Using a single SQL query and the material learned from chapters 1 - 5, I want you to provide me with the following set of summary information from the MurachCollege database. Provide a list of all of the students, the number of courses they are taking, and the number of different instructors they have across all of their courses. The first column should provide the last name of each student (column titled Student Last Name). The second column should provide the number of courses that each student is taking (column titled Number of Courses). The third column should provide the number of different instructors that each student has for all of the courses they are taking (column titled Number of Different Instructors).
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
