Find all employees in the sales department.
Use the NamanNavan (N2) Corporation database tables to design the following queries. (Use the spooling method to capture all queries and results in the CHAP7SP1.LST file.)
```
SQL> SELECT LNAME, FNAME, DEPTNAME
2 FROM EMPLOYEE E, DEPT D
3 WHERE E.DEPTID = D.DEPTID
4 AND UPPER(D.DEPTNAME) = 'SALES';
LNAME FNAME DEPTNAME
--------------- --------------- ------------
SHAW JINKU SALES
GARNER STANLEY SALES
```
You might also like to view...
Software that is distributed free along with the program source code is called:
A) closed source software. B) open source software. C) Microsoft Windows. D) outsource software.
A form that enables users to view but not change data is a(n) ________ form
Fill in the blank(s) with correct word
Contrast refers to the difference in brightness
Indicate whether the statement is true or false
Computer vision is the ability for a computer to interpret visual data as humans do.
Answer the following statement true (T) or false (F)