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