For each course ID, display the maximum count in descending order.

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


```
SQL> SELECT CourseId, Section, MaxCount
2 FROM crssection
3 ORDER BY CourseId, MaxCount DESC;

COURSE SE MAXCOUNT
------ -- ----------
AC101 10 35
CIS253 01 40
CIS253 21 40
CIS253 11 40
CIS253 31 2
CIS265 01 35
CIS265 01 30
CIS265 02 30
LA123 05 30
MA150 02 25
```

Computer Science & Information Technology

You might also like to view...

A ____________ is a special type of class member that allows an object to store and retrieve a piece of data.

a. variable b. field c. property d. method

Computer Science & Information Technology

The program included in the Java SDK that allows a programmer to separate the class interface from the class implementation is called:

a. javac b. java c. javadoc d. none of the above

Computer Science & Information Technology

The bleed area is defined in the document by a ____ guide.

A. blue B. green C. red D. black

Computer Science & Information Technology

In a recursive solution, the ______ terminates the recursive processing.

a) local environment b) pivot item c) base case d) recurrence relation

Computer Science & Information Technology