1. 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.
2. 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^th -100^th percentile (less than the top 50% percent). Use a subquery to determine the top 50% of enrollments.
3. 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.
4. 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.
5. Write a 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.
6. 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.