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...

Which of the following would indicate the usage of fiber?

A) 10BASE-36 B) 10BASE-F C) 10BASE-T4 D) 1000BASE-T

Computer Science & Information Technology

What are hidden fields used for on a Web form?

What will be an ideal response?

Computer Science & Information Technology

In a function, the range in parentheses is the ________

A) argument B) variable C) underlying value D) display value

Computer Science & Information Technology

Two of the most common e-mail errors stem from the user incorrectly specifying either ____.

A. the mailbox name or the computer name B. the username or the mailbox name C. the computer name or the server name D. the username or the user's address

Computer Science & Information Technology