# solved: Some faculty are grumbling that certain professors have an easy…

Some faculty are grumbling that certain professors have an easy…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): the code i come up with is not working and not sure what i am doing wrong the code i have is: select idfaculty, Faculty.FacFirstName||’ ‘||Faculty.FacLastName as ‘Faculty Name’, MAX(Offering.Capacity) AS maxCapacity, SUM(Offering.capacity) as ‘Sum of capacity’, count(Course.idCourse) As ‘How Many Classes’ from Faculty join Offering on idOffering=idFaculty join Course  on idCourse=idFacultygroup by idfacultyorder by maxCapacity ASC; second exercise i can not get anything to return anything is: 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. Generate SQL code to make a report which will do the followingGenerate a concatenated class name/number string, such as “FIN 200” from something in the Finance Department where the course number is 200Print that class name/number string in the first column of your reportPrint the class description (such as “Introduction to Finance”)List the student’s first name and then last nameList the offering term and the format (online or in person)List the professor’s first name and last nameSort 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 namethe code i came up with is :select c.CourseDept||’ ‘||c.CourseNumber, c.CourseDesc, s.stdFirstName, s.stdLastName,o.OffTerm,o.Format, f.FacFirstName, f.FacLastName from Course c JOIN Student son c.idCourse=s.idStudent Join Offering oon s.idStudent=o.idOffering join Faculty f on o.idOffering=f.idFaculty order by c.CourseDept||’ ‘||c.CourseNumber, stdLastName, stdFirstName; The joins in these exercise’s are a bit tricky for me.  For reference there are five tables in my database which are1.course2.enrollment3.faculty4.offering 5.student Computer ScienceEngineering & TechnologyMYSQLIFSM 330

Don't use plagiarized sources. Get Your Custom Essay on
solved: Some faculty are grumbling that certain professors have an easy…
Just from \$10/Page

## Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
\$26
The price is based on these factors:
Number of pages
Urgency
Basic features
• Free title page and bibliography
• Unlimited revisions
• Plagiarism-free guarantee
• Money-back guarantee
On-demand options
• Writer’s samples
• Part-by-part delivery
• Overnight delivery
• Copies of used sources
Paper format
• 275 words per page
• 12 pt Arial/Times New Roman
• Double line spacing
• Any citation style (APA, MLA, Chicago/Turabian, Harvard)

# Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

### Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

### Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

### Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.