Find all New York and New Jersey students.

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

```
SQL> SELECT StudentId, Last, First, State
2 FROM student
3 WHERE State = 'NY' OR State = 'NJ';

STUDE LAST FIRST ST
----- --------------- --------------- --
00100 Diaz Jose NJ
00101 Tyler Mickey NY
00102 Patel Rajesh NJ
00103 Rickles Deborah NJ
00104 Lee Brian NY
00105 Khan Amir NJ

6 rows selected.
```

Computer Science & Information Technology

You might also like to view...

Page Preview allows the user to see what the document will look like on paper before it is actually printed

Indicate whether the statement is true or false

Computer Science & Information Technology

What is the most important reason that you not touch the actual original evidence any more than you have to?

A. It can lead to data degradation. B. Each time you touch digital data, there is some chance of altering it. C. You might be accused of planting evidence. D. You might accidentally decrypt files.

Computer Science & Information Technology