Question: Using a single SQL query and the material learned from chapters 1 - 5 , I want you to provide me with the following set

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).

No other columns should be provided in the result.

Organize the result by student last name in alphabetical order.

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 Accounting Questions!