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

To print more than one copy of a document, use the ____________________ spin box.

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

Computer Science & Information Technology

When is a P E R T diagram useful for systems projects?

What will be an ideal response?

Computer Science & Information Technology

Which Cisco IOS commands can be used to display the interfaces that have been enabled into the local OSPF process?

A) show ip ospf interface brief B) show ip ospf C) show ip ospf enabled D) show ip ospf interface

Computer Science & Information Technology

By convention, Web pages that use an SSL/TLS connection start with ____________________ instead of http.

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

Computer Science & Information Technology