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
```
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
________ 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
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)
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