Get the terms, line numbers, course numbers, and course titles of courses along with their total enrollments
Get the terms, line numbers, and course titles of courses with the highest enrollments
Get the terms, line numbers, and course titles of courses that have enrollments greater than or equal to the average enrollments of all courses
Given a term and the line number of a course (for example, f95 and 1031), get the student ids, last names, and first names of students enrolled in the class along with each student's course average rounded off to the nearest integer. The course average is the sum of the weighted averages of the individual componentm scores.
Delete all the courses from the courses table that have enrollments of fewer than 2 students