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