| JOB | ENAME | SAL | COMM | EMPNO | MGR | HIREDATE | DEPTNO |
| ANALYST | SCOTT | 3000.00 | 7788 | 7566 | 13-JUL-87 | 20 | |
| FORD | 3000.00 | 7902 | 7566 | 03-DEC-81 | 20 | ||
| Sum | 6000.00 | 0.00 | |||||
| CLERK | SMITH | 800.00 | 7369 | 7902 | 17-DEC-80 | 20 | |
| ADAMS | 1100.00 | 7876 | 7788 | 13-JUL-87 | 20 | ||
| JAMES | 950.00 | 7900 | 7698 | 03-DEC-81 | 30 | ||
| MILLER | 1300.00 | 7934 | 7782 | 23-JAN-82 | 10 | ||
| Sum | 4150.00 | 0.00 | |||||
| MANAGER | JONES | 2975.00 | 7566 | 7839 | 02-APR-81 | 20 | |
| BLAKE | 2850.00 | 7698 | 7839 | 01-MAY-81 | 30 | ||
| CLARK | 2450.00 | 7782 | 7839 | 09-JUN-81 | 10 | ||
| Sum | 8275.00 | 0.00 | |||||
| PRESIDENT | KING | 5000.00 | 7839 | 17-NOV-81 | 10 | ||
| Sum | 5000.00 | 0.00 | |||||
| SALESMAN | ALLEN | 1600.00 | 300.00 | 7499 | 7698 | 20-FEB-81 | 30 |
| WARD | 1250.00 | 500.00 | 7521 | 7698 | 22-FEB-81 | 30 | |
| MARTIN | 1250.00 | 1400.00 | 7654 | 7698 | 28-SEP-81 | 30 | |
| TURNER | 1500.00 | 0.00 | 7844 | 7698 | 08-SEP-81 | 30 | |
| Sum | 5600.00 | 2200.00 | |||||
| 29025.00 | 2200.00 |