Display each employee’s name, department name, position description, and qualification description. Which employee is missing? Why?

Question

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

Answer 1

```
SQL> SELECT LNAME, FNAME, DEPTNAME, POSDESC, QUALDESC
2 FROM EMPLOYEE E, DEPT D, POSITION P, QUALIFICATION Q
3 WHERE E.DEPTID = D.DEPTID AND E.POSITIONID = P.POSITIONID
4 AND E.QUALID = Q.QUALID;

LNAME FNAME DEPTNAME POSDESC QUALDESC
--------------- --------------- -------------- ----------------- -------------
SMITH JOHN FINANCE PRESIDENT DOCTORATE
HOUSTON LARRY MARKETING MANAGER MASTERS
ROBERTS SANDI FINANCE MANAGER MASTERS
MCCALL ALEX INFOSYS PROGRAMMER ASSOCIATES
DEV DEREK INFOSYS MANAGER DOCTORATE
GARNER STANLEY SALES MANAGER HIGHSCHOOL
CHEN SUNNY FINANCE ACCOUNTANT BACHELORS

7 ROWS SELECTED.
(Jinku Shaw is missing as there is no QualId)
```