Find all information regarding classrooms (RoomType = ‘C’).

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 *
2 FROM location
3 WHERE RoomType =
4 (SELECT RoomType
5 FROm Room
6 WHERE RoomDesc = 'Classroom');

ROOMID BUILDIN ROO CAPACITY R
---------- ------- --- ---------- -
15 Nehru 301 50 C
16 Nehru 309 45 C
22 NEHRU 311 50 C
```

Computer Science & Information Technology

You might also like to view...

When discussing image file types, which of the following is NOT true?

A) Information is lost every time the file is saved in JPEG format. B) JPEG files are used for images in web pages. C) TIFF files have a higher compression ratio than JPEG files do. D) JPEG and TIFF are the two main file formats used by digital cameras.

Computer Science & Information Technology

To create your own throwable Exception, you usually extend a built-in ____ class.

A. ProblemHandle B. Problem C. Exception D. Error

Computer Science & Information Technology

What are common implementations of PKI?

What will be an ideal response?

Computer Science & Information Technology

The mouse shortcut for selecting a word is to ________ the word.

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

Computer Science & Information Technology