Find Spring 2003 course sections with the top three maximum count numbers.

Use the Indo–US College database tables to design the following subqueries. (Use the spooling method to capture all queries and results in the CHAP8SP2.LST file)


```
SQL> SELECT ROWNUM, CourseId, Section, MaxCount
2 FROM (SELECT CourseId, Section, MaxCount
3 FROM crssection
4 WHERE TermId = 'SP03'
5 ORDER BY MaxCount DESC)
6 WHERE ROWNUM <= 3;

ROWNUM COURSE SE MAXCOUNT
---------- ------ -- ----------
1 CIS253 21 40
2 CIS253 11 40
3 CIS265 01 35
```

Computer Science & Information Technology

You might also like to view...

To find a contribution amount of $300 or greater, the entry in the Amount field's criteria should be:

A) >=300. B) >300. C) 300. D) >=$300.

Computer Science & Information Technology

Once you have saved an image as a GIF file, you can insert it on a Web page using any program that creates ____.

A. Java B. HTML C. Perl D. Unix

Computer Science & Information Technology

Which of the following methods can be used to add elements to an array by pushing them onto the end of the array?

A. push B. append C. << D. A and C

Computer Science & Information Technology

Drag the R, G, and B color ____________________ to fine-tune the color selected on the color ramp shown in the accompanying figure.

Fill in the blank(s) with the appropriate word(s).

Computer Science & Information Technology