Display course description, total capacity and number of sections in each course, where there is more than 1 section.
What will be an ideal response?
```SELECT description, SUM(s.capacity), COUNT(*)
FROM course c, section s
WHERE c.course_no = s.course_no
GROUP by description
HAVING COUNT(*) > 1
```
Computer Science & Information Technology
You might also like to view...
When creating a form using the Form Wizard, all fields from the table being used must appear in the form
Indicate whether the statement is true or false
Computer Science & Information Technology
PowerPoint provides ____ built-in action buttons.
A. 8 B. 10 C. 12 D. 14
Computer Science & Information Technology