Display employee Jinku Shaw’s department name.

Use the N2 Corporation database tables to design the following subqueries. (Use the spooling method to capture all queries and results in the CHAP8SP1.LST file.)


```
SQL> SELECT DeptName
2 FROM Dept
3 WHERE DeptId =
4 (SELECT DeptId
5 FROM employee
6 WHERE UPPER(Lname) = 'SHAW'
7 AND UPPER(Fname) = 'JINKU');

DEPTNAME
------------
Sales
```

Computer Science & Information Technology

You might also like to view...

Which of the following statements correctly assigns the character M to the variable named letter?

a. letter = M b. letter = "M"; c. letter = 'M'; d. letter = (M); e. letter = M;

Computer Science & Information Technology

Internet Information Services (IIS) __________.

a. implements a professional-quality Web server b. contains minimal security and configuration features c. requires little expertise to set up and maintain d. all of the above

Computer Science & Information Technology

A(n) ____________________ is an area of RAM used for temporary storage.

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

Computer Science & Information Technology

A _____ might involve maximums for one or more resources, such as time, dollars, or people.

A. successor task B. constraint C. task ID D. milestone

Computer Science & Information Technology