Count the distinct building names in LOCATION.

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

```
SQL> SELECT COUNT(DISTINCT Building)
2 FROM location;

COUNT(DISTINCTBUILDING)
-----------------------
3
```

Computer Science & Information Technology

You might also like to view...

Where is the Add Layer Style icon located?

Quiz Questions What will be an ideal response?

Computer Science & Information Technology

Which of the following RAID configurations uses disk striping plus mirroring for fault tolerance?

A. RAID 0 B. RAID 10 C. RAID 1 D. RAID 5

Computer Science & Information Technology