Purchase Answers for $5

Instructions:Put your SQL in the "Problem 3"


Put your SQL in the "Problem 3" location in the SQL template.

Put your row count in the green box in cell D5.

Some faculty are grumbling that certain professors have an easy teaching load, defined as only a few courses with low capacity, while others have a heavy load of many courses with high seat counts.  Run a query to help answer this question. 

Your output should contain the faculty ID, faculty name (first and last – it’s fine to have this as two separate fields, also fine to concatenate together), the largest capacity class the faculty member is assigned to teach, the maximum possible total student load (sum of all the course capacities), and the number of classes the faculty member is teaching.

Include all faculty members, even if they are not assigned to teach any courses.  Include courses only if they are taught by a faculty member.  Sort your output ascending by the number of courses taught, with the professors with the fewest courses at the top.

For example, if you had the following input data (the blank row at the bottom means Professor Poldark did not teach anything):

Answers are locked, Purchase answers for $5.