Find sum of Maximum count by term by course. (GROUP BY two columns)

Question

Write queries for the following. (Use tables created in Chapter 4 Lab Activity.)

Answer 1

```
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.
```