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
```
You might also like to view...
Responsive design allows a web developer to specify different HTML code for some or all of a page's elements._________________________
Answer the following statement true (T) or false (F)
How many bytes does each use to represent a character?
What will be an ideal response?
Case EX 2-1Tessa's boss has asked her to improve the appearance of a worksheet. Please answer the questions below.Tessa wants to find and replace italic text with bold text. Where can she find the dialog box to do this?
A. On the Home tab, in the Editing group, click the Find & Select button, and then click Replace. B. On the Ribbon, in the Formatting group, click the Find & Select button, and then click Replace. C. On the Home tab, in the Proofing group, click the Find & Select button, and then click Find. D. None of the above.
Which computer design is best to use when a workstation will connect to a remote server?
A) Thin client B) Thick client C) CAD/CAM computer D) HTPC