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. (16 rows)
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...
Access will automatically round all numbers used in the DATEADD function to the nearest whole number
Indicate whether the statement is true or false
Computer Science & Information Technology
Which of the following is an alternative to a combo box?
A) Make it a required field B) Add a data validation rule C) Set a tab order D) Key in the field
Computer Science & Information Technology