solutions

Description


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. 

Question

solutions

  • Written in: 17-Oct-2019
  • Paper ID: 82685023
Price: $ 40
 

Use the Order Now button below to Place a New Order for an Original, High-Quality Paper that passes all Plagiarism Checkers

Order Now




About this Question

STATUS

DATE ANSWERED

Oct 17, 2019

EXPERT

N/A

ANSWER RATING

Need Help with an Assignment?

Get Help with an Assignment

SSL Certificate website security