Display the course number, number of sections and total capacity for courses having more than 3 sections.( 9 rows).

What will be an ideal response?


```
SELECT course_no Course, COUNT(section_no) "Section Count",
SUM(capacity) Capacity
FROM section
GROUP BY course_no
HAVING COUNT(section_no) > 3
```

Computer Science & Information Technology

You might also like to view...

What approach to security calls for security through a variety of defensive techniques that work together?

A. DOA B. WoL C. DiD D. PoE

Computer Science & Information Technology

________ are a collection of millions of tiny electrical switches that compose the central part of a computer

A) Converters B) Transistors C) Sampling rates D) Microprocessors

Computer Science & Information Technology

Long after you send an e-mail message, you will see the e-mail stored in the Outbox.

Answer the following statement true (T) or false (F)

Computer Science & Information Technology

A well documented Window's OS vulnerability was null sessions. What Windows operating system was the first to disable null sessions by default?

A. Windows Server 2012 B. Windows Server 2008 C. Windows Server 2003 D. Windows 8.1

Computer Science & Information Technology