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...

________ is designed to convey an idea using a variety of drawn images, photos, cartoon-like images, sounds, or movie clips

A) Clip art B) A bulleted list C) An anchor D) A theme

Computer Science & Information Technology

A ________ control is an unbound control

A) combo box B) text box C) label D) tab order

Computer Science & Information Technology

A________ is a pointer to a cell in another worksheet

Fill in the blank(s) with correct word

Computer Science & Information Technology

To switch to the Site Summary report from the report of verified hyperlinks, click the ____, as shown in the accompanying figure.

A. Hyperlinks button arrow B. Status indicator C. Page title D. Destination

Computer Science & Information Technology