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
```
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;
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
A(n) ____________________ is an area of RAM used for temporary storage.
Fill in the blank(s) with the appropriate word(s).
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