Find sum of Maximum count by term by course. (GROUP BY two columns)
Write queries for the following. (Use tables created in Chapter 4 Lab Activity.)
```
SQL> SELECT TermId, CourseId, SUM(MaxCount)
2 FROM crssection
3 GROUP BY TermId, CourseId;
TERM COURSE SUM(MAXCOUNT)
---- ------ -------------
SP03 LA123 30
SP03 CIS253 82
SP03 CIS265 65
WN03 AC101 35
WN03 MA150 25
WN03 CIS253 40
WN03 CIS265 30
7 rows selected.
```
Computer Science & Information Technology
You might also like to view...
The ReadToEnd method reads a file line by line all the way to the end.
Answer the following statement true (T) or false (F)
Computer Science & Information Technology
____ is based on the size of registers in the processor and the capacity of circuits that lead to those registers.
A. Character size B. Word size C. Byte size D. Bit size
Computer Science & Information Technology