Assignment
1. Display the number of courses with a total revenue more than $20,000, the total enrollment for those courses, and the average total revenue for those courses.
2. Count the number of courses taught by all adjunct and full time faculty members during the semester and their total enrollments for all classes they teach.
3. Only faculty members with a total revenue of $10,000 for all their courses will be retained for the current semester. List faculty members by ID who will be retained for the semester along with their total revenues.
4. List only first and last names of all full time faculty members who are teaching more than 2 courses and the total enrollment for those courses.
5. Display the last names of all adjunct faculty members whether or not they are teaching. Display the number of courses each faculty member is teaching, Also display the overall total number of courses taught by adjuncts.
6. Display the total number of courses taught by each faculty member each term, the total number of courses offered during each term, the total number of courses offered for all terms, and the total number of courses taught by each faculty member for all terms.