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
```
You might also like to view...
The ____________ is critical to ICT acquisition because it provides the sole point of reference for the bidding process.
Fill in the blank(s) with the appropriate word(s).
What is wrong with the following program?
What will be an ideal response?