Using a correlated sub-query, display course name, course number and the average capacity of all sections of each course, rounded to 4 decimal places, where students are enrolled, and the average capacity is less than 25 . Use a column alias of AVERAGE_CAPACITY to represent the number.
What will be an ideal response?
```SELECT description, c.course_no, ROUND(AVG(capacity), 4)
AVERAGE_CAPACITY
FROM section s, course c
WHERE c.course_no = s.course_no
AND EXISTS (SELECT null
FROM enrollment e
WHERE e.section_id=s.section_id)
GROUP BY description, c.course_no
HAVING ROUND(AVG(capacity), 4) < 25```
Computer Science & Information Technology
You might also like to view...
When you ________ the movie, it combines all of the elements that you have gathered in your Storyboard or Timeline, and creates a single movie file
Fill in the blank(s) with correct word
Computer Science & Information Technology
To safeguard belongings and identity from dedicated criminals, it is important to develop alternate means of identity authentication
Indicate whether the statement is true or false.
Computer Science & Information Technology