Statement number 1 ENAME ---------- ALLEN WARD MARTIN TURNER JAMES Statement number 2 ENAME Annual Salary ---------- ------------- SMITH 9600 JAMES 11400 ADAMS 13200 MILLER 15600 TURNER 18000 WARD 21000 ALLEN 22800 CLARK 29400 MARTIN 31800 BLAKE 34200 JONES 35700 FORD 36000 SCOTT 36000 KING 60000 14 rows selected. Statement number 3 ENAME PERCENT INC ---------- ----------- KING 0 CLARK 104.08163 MILLER 284.61538 Statement number 4 DNAME LC --------------- -- ACCOUNTING NY RESEARCH DA SALES CH OPERATIONS BO Statement number 5 FIRST DAY --------- 01-AUG-97 Statement number 6 LAST DAY --------- 31-AUG-97 Statement number 7 ENAME HIREDATE ---------- --------------- JONES April 1991 FORD December 1991 JAMES December 1991 SCOTT December 1992 SMITH December 1994 WARD February 1994 ALLEN February 1995 MILLER January 1992 ADAMS January 1993 CLARK June 1991 BLAKE May 1991 KING November 1991 TURNER September 1991 MARTIN September 1995 14 rows selected. Statement number 8 ENAME SAL COMM ---------- --------- --------- KING 5000 0 JONES 2975 0 BLAKE 2850 0 CLARK 2450 0 FORD 3000 0 SMITH 800 0 ALLEN 1600 300 WARD 1250 500 MARTIN 1250 1400 SCOTT 3000 0 TURNER 1500 0 ADAMS 1100 0 JAMES 950 0 MILLER 1300 0 14 rows selected. Statement number 9 ENAME JOB HIREDATE PROMOTION ---------- ---------- --------- --------- FORD ANALYST 03-DEC-91 02-DEC-92 SCOTT ANALYST 09-DEC-92 09-DEC-93 SMITH CLERK 17-DEC-94 17-MAR-95 ADAMS CLERK 12-JAN-93 12-APR-93 MILLER CLERK 23-JAN-92 22-APR-92 JAMES CLERK 03-DEC-91 02-MAR-92 JONES MANAGER 02-APR-91 29-SEP-91 BLAKE MANAGER 01-MAY-91 28-OCT-91 CLARK MANAGER 09-JUN-91 06-DEC-91 KING PRESIDENT 17-NOV-91 16-NOV-92 ALLEN SALESMAN 20-FEB-95 20-FEB-96 WARD SALESMAN 22-FEB-94 22-FEB-95 TURNER SALESMAN 08-SEP-91 07-SEP-92 MARTIN SALESMAN 28-SEP-95 27-SEP-96 14 rows selected. Statement number 10 ENAME ---------- KING CLARK MILLER Statement number 11 DNAME --------------- ACCOUNTING RESEARCH SALES Statement number 12 ENAME ---------- ALLEN WARD MARTIN TURNER JAMES Statement number 13 ENAME ---------- JONES BLAKE CLARK ALLEN WARD TURNER MARTIN 7 rows selected. Statement number 14 LOC DNAME DEPTNO ENAME ---------- --------------- --------- ---------- NEW YORK ACCOUNTING 10 KING DALLAS RESEARCH 20 JONES CHICAGO SALES 30 BLAKE NEW YORK ACCOUNTING 10 CLARK DALLAS RESEARCH 20 FORD DALLAS RESEARCH 20 SMITH CHICAGO SALES 30 ALLEN CHICAGO SALES 30 WARD CHICAGO SALES 30 MARTIN DALLAS RESEARCH 20 SCOTT CHICAGO SALES 30 TURNER DALLAS RESEARCH 20 ADAMS CHICAGO SALES 30 JAMES NEW YORK ACCOUNTING 10 MILLER 14 rows selected. Statement number 15 ENAME LOC ---------- ---------- BLAKE CHICAGO ALLEN CHICAGO WARD CHICAGO TURNER CHICAGO JAMES CHICAGO MARTIN CHICAGO JONES DALLAS ADAMS DALLAS SCOTT DALLAS FORD DALLAS SMITH DALLAS KING NEW YORK CLARK NEW YORK MILLER NEW YORK 14 rows selected. Statement number 16 ENAME LOC ---------- ---------- BLAKE CHICAGO ALLEN CHICAGO MARTIN CHICAGO JAMES CHICAGO TURNER CHICAGO WARD CHICAGO JONES DALLAS FORD DALLAS SCOTT DALLAS ADAMS DALLAS SMITH DALLAS 11 rows selected. Statement number 17 ENAME LOC ---------- ---------- KING NEW YORK Statement number 18 ENAME SAL ---------- --------- JONES 2975 BLAKE 2850 CLARK 2450 FORD 3000 SCOTT 3000 Statement number 19 ENAME SAL ---------- --------- BLAKE 2850 FORD 3000 SCOTT 3000 Statement number 20 ENAME DNAME DEPTNO LOC ---------- --------------- --------- ---------- KING ACCOUNTING 10 NEW YORK CLARK ACCOUNTING 10 NEW YORK MILLER ACCOUNTING 10 NEW YORK JONES RESEARCH 20 DALLAS SMITH RESEARCH 20 DALLAS FORD RESEARCH 20 DALLAS SCOTT RESEARCH 20 DALLAS ADAMS RESEARCH 20 DALLAS BLAKE SALES 30 CHICAGO ALLEN SALES 30 CHICAGO WARD SALES 30 CHICAGO JAMES SALES 30 CHICAGO TURNER SALES 30 CHICAGO MARTIN SALES 30 CHICAGO OPERATIONS 40 BOSTON 15 rows selected. Statement number 21 EMP MGR ---------- ---------- ALLEN BLAKE WARD BLAKE MARTIN BLAKE JAMES BLAKE TURNER BLAKE MILLER CLARK SMITH FORD FORD JONES SCOTT JONES JONES KING BLAKE KING CLARK KING ADAMS SCOTT 13 rows selected. Statement number 22 LOC EMP COUNT ---------- --------- CHICAGO 6 DALLAS 5 NEW YORK 3 Statement number 23 HIRE COUNT(*) ----- --------- 91 7 92 2 93 1 94 2 95 2