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.
```
You might also like to view...
Which of the following is not considered to be type of database client?
A. Local software B. Browsers C. Apps D. All of the above
Brigid cannot find one of the workspaces on the menu bar. What should she do?
a. click the Workspace Switcher b. click the status bar c. click the options bar d. click the Workspace menu