Question

Write a SQL statement to display course name, course number, and the average capacity of all sectionsof each course, rounded to four decimal places, where students are enrolled, and the average capacityis less than twenty five (use a correlated sub-query and use a column alias of AVERAGECAPACITY torepresent the number.

Answer 1

SELECT C. DESCRIPTION, C. COURSE_NO, ROUND(AVG(CAPACITY), 4) AS AVERAGECAPACITY

FROM COURSE C, SECTION S

WHERE C. COURSE_NO = S. COURSE_NO

GROUP BY C. COURSE_NO

HAVING AVG(CAPACITY)<25