View the step-by-step solution to:

Question

<ol><li>Select the first names, last names, course reference numbers, and enrollments of all adjunct

faculty members who are teaching courses during the term that have an enrollment higher than the average enrollment. Use a subquery to obtain the average enrollment per class.</li><li>Select the full-time faculty member first name, last name, reference number and enrollment for courses that have an enrollment less that of all courses in the 50<sup>th</sup> -100<sup>th</sup> percentile (less than the top 50% percent). Use a subquery to determine the top 50% of enrollments.</li><li>Select all full-time faculty members who are teaching more than 2 courses. Use a subquery to obtain from the Courses table all full time faculty members who are teaching a total of more than two courses.</li><li>Select the first name, last name, course reference number and enrollment for the course with the highest enrollment for each full time faculty member. Use a subquery to obtain the maximum enrollment for each full time faculty member.</li><li>enter query that will select the highest enrollment for each faculty member (including adjuncts) among courses taught during the term, and return the sum of the highest enrollments. Use a subquery to obtain the maximum enrollment for each full time faculty member.</li><li>Repeat #5, using a CTE that consists of a derived table to select the highest enrollment of all classes for each faculty member. Use a SELECT statement that references the derived table to obtain a total of the highest enrollments. </li></ol>

Recently Asked Questions

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question
Let our 24/7 MYSQL tutors help you get unstuck! Ask your first question.
A+ icon
Ask Expert Tutors You can ask You can ask You can ask (will expire )
Answers in as fast as 15 minutes
A+ icon
Ask Expert Tutors