Display course description, total capacity and number of sections in each course, where there is more than 1 section. (18 rows)
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...
An office suite is also sometimes called a(n) ________ suite
Fill in the blank(s) with correct word
Computer Science & Information Technology
The ________ Amendment of the Constitution deals with search and seizure
Fill in the blank(s) with the appropriate word(s).
Computer Science & Information Technology
It is good practice to make a backup copy of a database before using the Database Splitter to split the database into two files.
Answer the following statement true (T) or false (F)
Computer Science & Information Technology
To create a compound condition in an If statement, a(n) ____ operator is required.
A. compound B. logical C. arithmetic D. logical
Computer Science & Information Technology