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```
You might also like to view...
Class Arrays provides method __________ for comparing arrays to determine whether they have the same contents
a. compare b. compares c. equal d. equals
What is a conceptual host model?
What will be an ideal response?
Which of the following is MOST true?
A) Case studies offer generalizations on cybercriminals B) Most research of cybercrime focuses on behavioral approaches C) Early researchers felt that computer crime would be a large problem D) A great deal of effort is dedicated to computer security
Depending on the manufacturer of the BIOS, what two different POST beep code sequences indicate a memory error?
A. continuous short beeps B. continuous three short beeps and then a pause C. continuous two short beeps and then a pause D. eight short beeps