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...
A system administrator is tasked with dividing the network so that each department is separate from the other. Which of the following should be used to accomplish this task?
A. VLAN B. VPN C. VNC D. VM
During an interview, the analyst should get the ________ of the interviewees, their feelings, organizational and personal goals, and informal procedures.
A) concerns B) opinions C) objections D) None of the above.