Find rooms with bottom-2 capacities. Do not include office rooms.
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, Building, RoomNo, Capacity
2 FROM (SELECT Building, RoomNo, Capacity
3 FROM location
4 WHERE RoomType <> 'O'
5 ORDER BY Capacity)
6 WHERE ROWNUM <= 2;
ROWNUM BUILDIN ROO CAPACITY
---------- ------- --- ----------
1 Kennedy 210 30
2 Kennedy 202 35
```
You might also like to view...
The second edition of the SSE-CMM was approved by the ISO in what year?
A. 1993 B. 1998 C. 2002 D. 2008
Which component of the Hyper-V architecture controls all communication with the physical hardware on the computer?
A. Hypervisor B. Child Partition C. Integration Services D. Parent partition
How many times is the recursive moveDisks method invoked for 3 disks?
a. 3 b. 7 c. 10 d. 14
(Calculating Number of Seconds) Write a function that takes the time as three integer ar- guments (hours, minutes and seconds) and returns the number of seconds since the last time the clock “struck 12.” Use this function to calculate the amount of time in seconds between two times, both of which are within one 12-hour cycle of the clock.
What will be an ideal response?