EMPL_LAST_NAME SALARY
--------------- ----------
Scott 3000
Turner 1500
Miller 1300
Jones 2975
Raimi 2450
Michaels 1600
Ford 3000
Adams 1100
James 950
Smith 800
Ward 1250
EMPL_LAST_NAME SALARY
--------------- ----------
King 5000
Blake 2850
Martin 1250
14 rows selected.
JOB_TITLE DEP
---------- ---
Manager 100
Salesman 300
Clerk 100
Manager 200
Manager 300
Clerk 400
President 500
Analyst 200
Clerk 200
Clerk 300
10 rows selected.
JOB_TITLE DEP
---------- ---
President 500
Manager 200
Manager 300
Manager 100
Analyst 200
Clerk 200
Salesman 300
Salesman 300
Salesman 300
Analyst 200
Salesman 300
JOB_TITLE DEP
---------- ---
Clerk 400
Clerk 300
Clerk 100
14 rows selected.
EMPL EMPL_LAST_NAME JOB_TITLE MGR HIREDATE SALARY COMMISSION DEP
---- --------------- ---------- ---- --------- ---------- ---------- ---
7839 King President 17-NOV-91 5000 500
7566 Jones Manager 7839 02-APR-91 2975 200
7698 Blake Manager 7839 01-MAY-91 2850 300
7902 Ford Analyst 7566 03-DEC-91 3000 200
7788 Scott Analyst 7566 09-NOV-91 3000 200
EMPL EMPL_LAST_NAME JOB_TITLE MGR HIREDATE SALARY COMMISSION DEP
---- --------------- ---------- ---- --------- ---------- ---------- ---
7839 King President 17-NOV-91 5000 500
EMPL EMPL_LAST_NAME JOB_TITLE MGR HIREDATE SALARY COMMISSION DEP
---- --------------- ---------- ---- --------- ---------- ---------- ---
7499 Michaels Salesman 7698 20-FEB-91 1600 300 300
7521 Ward Salesman 7698 22-FEB-91 1250 500 300
7654 Martin Salesman 7698 28-SEP-91 1250 1400 300
7844 Turner Salesman 7698 08-SEP-91 1500 0 300
no rows selected
EMPL EMPL_LAST_NAME JOB_TITLE MGR HIREDATE SALARY COMMISSION DEP DEP
---- --------------- ---------- ---- --------- ---------- ---------- --- ---
DEPT_NAME DEPT_LOC
--------------- ---------------
7839 King President 17-NOV-91 5000 500 500
Management New York
7566 Jones Manager 7839 02-APR-91 2975 200 200
Research Dallas
7698 Blake Manager 7839 01-MAY-91 2850 300 300
Sales Chicago
EMPL EMPL_LAST_NAME JOB_TITLE MGR HIREDATE SALARY COMMISSION DEP DEP
---- --------------- ---------- ---- --------- ---------- ---------- --- ---
DEPT_NAME DEPT_LOC
--------------- ---------------
7782 Raimi Manager 7839 09-JUN-91 2450 100 100
Accounting New York
7902 Ford Analyst 7566 03-DEC-91 3000 200 200
Research Dallas
7369 Smith Clerk 7902 17-DEC-90 800 200 200
Research Dallas
EMPL EMPL_LAST_NAME JOB_TITLE MGR HIREDATE SALARY COMMISSION DEP DEP
---- --------------- ---------- ---- --------- ---------- ---------- --- ---
DEPT_NAME DEPT_LOC
--------------- ---------------
7499 Michaels Salesman 7698 20-FEB-91 1600 300 300 300
Sales Chicago
7521 Ward Salesman 7698 22-FEB-91 1250 500 300 300
Sales Chicago
7654 Martin Salesman 7698 28-SEP-91 1250 1400 300 300
Sales Chicago
EMPL EMPL_LAST_NAME JOB_TITLE MGR HIREDATE SALARY COMMISSION DEP DEP
---- --------------- ---------- ---- --------- ---------- ---------- --- ---
DEPT_NAME DEPT_LOC
--------------- ---------------
7788 Scott Analyst 7566 09-NOV-91 3000 200 200
Research Dallas
7844 Turner Salesman 7698 08-SEP-91 1500 0 300 300
Sales Chicago
7876 Adams Clerk 7788 23-SEP-91 1100 400 400
Operations Boston
EMPL EMPL_LAST_NAME JOB_TITLE MGR HIREDATE SALARY COMMISSION DEP DEP
---- --------------- ---------- ---- --------- ---------- ---------- --- ---
DEPT_NAME DEPT_LOC
--------------- ---------------
7900 James Clerk 7698 03-DEC-91 950 300 300
Sales Chicago
7934 Miller Clerk 7782 23-JAN-92 1300 100 100
Accounting New York
14 rows selected.
EMPL EMPL_LAST_NAME JOB_TITLE MGR HIREDATE SALARY COMMISSION DEP DEP
---- --------------- ---------- ---- --------- ---------- ---------- --- ---
DEPT_NAME DEPT_LOC
--------------- ---------------
7839 King President 17-NOV-91 5000 500 100
Accounting New York
7566 Jones Manager 7839 02-APR-91 2975 200 100
Accounting New York
7698 Blake Manager 7839 01-MAY-91 2850 300 100
Accounting New York
EMPL EMPL_LAST_NAME JOB_TITLE MGR HIREDATE SALARY COMMISSION DEP DEP
---- --------------- ---------- ---- --------- ---------- ---------- --- ---
DEPT_NAME DEPT_LOC
--------------- ---------------
7782 Raimi Manager 7839 09-JUN-91 2450 100 100
Accounting New York
7902 Ford Analyst 7566 03-DEC-91 3000 200 100
Accounting New York
7369 Smith Clerk 7902 17-DEC-90 800 200 100
Accounting New York
EMPL EMPL_LAST_NAME JOB_TITLE MGR HIREDATE SALARY COMMISSION DEP DEP
---- --------------- ---------- ---- --------- ---------- ---------- --- ---
DEPT_NAME DEPT_LOC
--------------- ---------------
7499 Michaels Salesman 7698 20-FEB-91 1600 300 300 100
Accounting New York
7521 Ward Salesman 7698 22-FEB-91 1250 500 300 100
Accounting New York
7654 Martin Salesman 7698 28-SEP-91 1250 1400 300 100
Accounting New York
EMPL EMPL_LAST_NAME JOB_TITLE MGR HIREDATE SALARY COMMISSION DEP DEP
---- --------------- ---------- ---- --------- ---------- ---------- --- ---
DEPT_NAME DEPT_LOC
--------------- ---------------
7788 Scott Analyst 7566 09-NOV-91 3000 200 100
Accounting New York
7844 Turner Salesman 7698 08-SEP-91 1500 0 300 100
Accounting New York
7876 Adams Clerk 7788 23-SEP-91 1100 400 100
Accounting New York
EMPL EMPL_LAST_NAME JOB_TITLE MGR HIREDATE SALARY COMMISSION DEP DEP
---- --------------- ---------- ---- --------- ---------- ---------- --- ---
DEPT_NAME DEPT_LOC
--------------- ---------------
7900 James Clerk 7698 03-DEC-91 950 300 100
Accounting New York
7934 Miller Clerk 7782 23-JAN-92 1300 100 100
Accounting New York
7839 King President 17-NOV-91 5000 500 200
Research Dallas
EMPL EMPL_LAST_NAME JOB_TITLE MGR HIREDATE SALARY COMMISSION DEP DEP
---- --------------- ---------- ---- --------- ---------- ---------- --- ---
DEPT_NAME DEPT_LOC
--------------- ---------------
7566 Jones Manager 7839 02-APR-91 2975 200 200
Research Dallas
7698 Blake Manager 7839 01-MAY-91 2850 300 200
Research Dallas
7782 Raimi Manager 7839 09-JUN-91 2450 100 200
Research Dallas
EMPL EMPL_LAST_NAME JOB_TITLE MGR HIREDATE SALARY COMMISSION DEP DEP
---- --------------- ---------- ---- --------- ---------- ---------- --- ---
DEPT_NAME DEPT_LOC
--------------- ---------------
7902 Ford Analyst 7566 03-DEC-91 3000 200 200
Research Dallas
7369 Smith Clerk 7902 17-DEC-90 800 200 200
Research Dallas
7499 Michaels Salesman 7698 20-FEB-91 1600 300 300 200
Research Dallas
EMPL EMPL_LAST_NAME JOB_TITLE MGR HIREDATE SALARY COMMISSION DEP DEP
---- --------------- ---------- ---- --------- ---------- ---------- --- ---
DEPT_NAME DEPT_LOC
--------------- ---------------
7521 Ward Salesman 7698 22-FEB-91 1250 500 300 200
Research Dallas
7654 Martin Salesman 7698 28-SEP-91 1250 1400 300 200
Research Dallas
7788 Scott Analyst 7566 09-NOV-91 3000 200 200
Research Dallas
EMPL EMPL_LAST_NAME JOB_TITLE MGR HIREDATE SALARY COMMISSION DEP DEP
---- --------------- ---------- ---- --------- ---------- ---------- --- ---
DEPT_NAME DEPT_LOC
--------------- ---------------
7844 Turner Salesman 7698 08-SEP-91 1500 0 300 200
Research Dallas
7876 Adams Clerk 7788 23-SEP-91 1100 400 200
Research Dallas
7900 James Clerk 7698 03-DEC-91 950 300 200
Research Dallas
EMPL EMPL_LAST_NAME JOB_TITLE MGR HIREDATE SALARY COMMISSION DEP DEP
---- --------------- ---------- ---- --------- ---------- ---------- --- ---
DEPT_NAME DEPT_LOC
--------------- ---------------
7934 Miller Clerk 7782 23-JAN-92 1300 100 200
Research Dallas
7839 King President 17-NOV-91 5000 500 300
Sales Chicago
7566 Jones Manager 7839 02-APR-91 2975 200 300
Sales Chicago
EMPL EMPL_LAST_NAME JOB_TITLE MGR HIREDATE SALARY COMMISSION DEP DEP
---- --------------- ---------- ---- --------- ---------- ---------- --- ---
DEPT_NAME DEPT_LOC
--------------- ---------------
7698 Blake Manager 7839 01-MAY-91 2850 300 300
Sales Chicago
7782 Raimi Manager 7839 09-JUN-91 2450 100 300
Sales Chicago
7902 Ford Analyst 7566 03-DEC-91 3000 200 300
Sales Chicago
EMPL EMPL_LAST_NAME JOB_TITLE MGR HIREDATE SALARY COMMISSION DEP DEP
---- --------------- ---------- ---- --------- ---------- ---------- --- ---
DEPT_NAME DEPT_LOC
--------------- ---------------
7369 Smith Clerk 7902 17-DEC-90 800 200 300
Sales Chicago
7499 Michaels Salesman 7698 20-FEB-91 1600 300 300 300
Sales Chicago
7521 Ward Salesman 7698 22-FEB-91 1250 500 300 300
Sales Chicago
EMPL EMPL_LAST_NAME JOB_TITLE MGR HIREDATE SALARY COMMISSION DEP DEP
---- --------------- ---------- ---- --------- ---------- ---------- --- ---
DEPT_NAME DEPT_LOC
--------------- ---------------
7654 Martin Salesman 7698 28-SEP-91 1250 1400 300 300
Sales Chicago
7788 Scott Analyst 7566 09-NOV-91 3000 200 300
Sales Chicago
7844 Turner Salesman 7698 08-SEP-91 1500 0 300 300
Sales Chicago
EMPL EMPL_LAST_NAME JOB_TITLE MGR HIREDATE SALARY COMMISSION DEP DEP
---- --------------- ---------- ---- --------- ---------- ---------- --- ---
DEPT_NAME DEPT_LOC
--------------- ---------------
7876 Adams Clerk 7788 23-SEP-91 1100 400 300
Sales Chicago
7900 James Clerk 7698 03-DEC-91 950 300 300
Sales Chicago
7934 Miller Clerk 7782 23-JAN-92 1300 100 300
Sales Chicago
EMPL EMPL_LAST_NAME JOB_TITLE MGR HIREDATE SALARY COMMISSION DEP DEP
---- --------------- ---------- ---- --------- ---------- ---------- --- ---
DEPT_NAME DEPT_LOC
--------------- ---------------
7839 King President 17-NOV-91 5000 500 400
Operations Boston
7566 Jones Manager 7839 02-APR-91 2975 200 400
Operations Boston
7698 Blake Manager 7839 01-MAY-91 2850 300 400
Operations Boston
EMPL EMPL_LAST_NAME JOB_TITLE MGR HIREDATE SALARY COMMISSION DEP DEP
---- --------------- ---------- ---- --------- ---------- ---------- --- ---
DEPT_NAME DEPT_LOC
--------------- ---------------
7782 Raimi Manager 7839 09-JUN-91 2450 100 400
Operations Boston
7902 Ford Analyst 7566 03-DEC-91 3000 200 400
Operations Boston
7369 Smith Clerk 7902 17-DEC-90 800 200 400
Operations Boston
EMPL EMPL_LAST_NAME JOB_TITLE MGR HIREDATE SALARY COMMISSION DEP DEP
---- --------------- ---------- ---- --------- ---------- ---------- --- ---
DEPT_NAME DEPT_LOC
--------------- ---------------
7499 Michaels Salesman 7698 20-FEB-91 1600 300 300 400
Operations Boston
7521 Ward Salesman 7698 22-FEB-91 1250 500 300 400
Operations Boston
7654 Martin Salesman 7698 28-SEP-91 1250 1400 300 400
Operations Boston
EMPL EMPL_LAST_NAME JOB_TITLE MGR HIREDATE SALARY COMMISSION DEP DEP
---- --------------- ---------- ---- --------- ---------- ---------- --- ---
DEPT_NAME DEPT_LOC
--------------- ---------------
7788 Scott Analyst 7566 09-NOV-91 3000 200 400
Operations Boston
7844 Turner Salesman 7698 08-SEP-91 1500 0 300 400
Operations Boston
7876 Adams Clerk 7788 23-SEP-91 1100 400 400
Operations Boston
EMPL EMPL_LAST_NAME JOB_TITLE MGR HIREDATE SALARY COMMISSION DEP DEP
---- --------------- ---------- ---- --------- ---------- ---------- --- ---
DEPT_NAME DEPT_LOC
--------------- ---------------
7900 James Clerk 7698 03-DEC-91 950 300 400
Operations Boston
7934 Miller Clerk 7782 23-JAN-92 1300 100 400
Operations Boston
7839 King President 17-NOV-91 5000 500 500
Management New York
EMPL EMPL_LAST_NAME JOB_TITLE MGR HIREDATE SALARY COMMISSION DEP DEP
---- --------------- ---------- ---- --------- ---------- ---------- --- ---
DEPT_NAME DEPT_LOC
--------------- ---------------
7566 Jones Manager 7839 02-APR-91 2975 200 500
Management New York
7698 Blake Manager 7839 01-MAY-91 2850 300 500
Management New York
7782 Raimi Manager 7839 09-JUN-91 2450 100 500
Management New York
EMPL EMPL_LAST_NAME JOB_TITLE MGR HIREDATE SALARY COMMISSION DEP DEP
---- --------------- ---------- ---- --------- ---------- ---------- --- ---
DEPT_NAME DEPT_LOC
--------------- ---------------
7902 Ford Analyst 7566 03-DEC-91 3000 200 500
Management New York
7369 Smith Clerk 7902 17-DEC-90 800 200 500
Management New York
7499 Michaels Salesman 7698 20-FEB-91 1600 300 300 500
Management New York
EMPL EMPL_LAST_NAME JOB_TITLE MGR HIREDATE SALARY COMMISSION DEP DEP
---- --------------- ---------- ---- --------- ---------- ---------- --- ---
DEPT_NAME DEPT_LOC
--------------- ---------------
7521 Ward Salesman 7698 22-FEB-91 1250 500 300 500
Management New York
7654 Martin Salesman 7698 28-SEP-91 1250 1400 300 500
Management New York
7788 Scott Analyst 7566 09-NOV-91 3000 200 500
Management New York
EMPL EMPL_LAST_NAME JOB_TITLE MGR HIREDATE SALARY COMMISSION DEP DEP
---- --------------- ---------- ---- --------- ---------- ---------- --- ---
DEPT_NAME DEPT_LOC
--------------- ---------------
7844 Turner Salesman 7698 08-SEP-91 1500 0 300 500
Management New York
7876 Adams Clerk 7788 23-SEP-91 1100 400 500
Management New York
7900 James Clerk 7698 03-DEC-91 950 300 500
Management New York
EMPL EMPL_LAST_NAME JOB_TITLE MGR HIREDATE SALARY COMMISSION DEP DEP
---- --------------- ---------- ---- --------- ---------- ---------- --- ---
DEPT_NAME DEPT_LOC
--------------- ---------------
7934 Miller Clerk 7782 23-JAN-92 1300 100 500
Management New York
70 rows selected.
EMPL EMPL_LAST_NAME JOB_TITLE MGR SALARY COMMISSION DEP DEPT_NAME
---- --------------- ---------- ---- ---------- ---------- --- ---------------
DEPT_LOC
---------------
7839 King President 5000 500 Management
New York
7566 Jones Manager 7839 2975 200 Research
Dallas
7698 Blake Manager 7839 2850 300 Sales
Chicago
EMPL EMPL_LAST_NAME JOB_TITLE MGR SALARY COMMISSION DEP DEPT_NAME
---- --------------- ---------- ---- ---------- ---------- --- ---------------
DEPT_LOC
---------------
7782 Raimi Manager 7839 2450 100 Accounting
New York
7902 Ford Analyst 7566 3000 200 Research
Dallas
7369 Smith Clerk 7902 800 200 Research
Dallas
EMPL EMPL_LAST_NAME JOB_TITLE MGR SALARY COMMISSION DEP DEPT_NAME
---- --------------- ---------- ---- ---------- ---------- --- ---------------
DEPT_LOC
---------------
7499 Michaels Salesman 7698 1600 300 300 Sales
Chicago
7521 Ward Salesman 7698 1250 500 300 Sales
Chicago
7654 Martin Salesman 7698 1250 1400 300 Sales
Chicago
EMPL EMPL_LAST_NAME JOB_TITLE MGR SALARY COMMISSION DEP DEPT_NAME
---- --------------- ---------- ---- ---------- ---------- --- ---------------
DEPT_LOC
---------------
7788 Scott Analyst 7566 3000 200 Research
Dallas
7844 Turner Salesman 7698 1500 0 300 Sales
Chicago
7876 Adams Clerk 7788 1100 400 Operations
Boston
EMPL EMPL_LAST_NAME JOB_TITLE MGR SALARY COMMISSION DEP DEPT_NAME
---- --------------- ---------- ---- ---------- ---------- --- ---------------
DEPT_LOC
---------------
7900 James Clerk 7698 950 300 Sales
Chicago
7934 Miller Clerk 7782 1300 100 Accounting
New York
14 rows selected.
EMPL EMPL_LAST_NAME JOB_TITLE MGR HIREDATE SALARY COMMISSION DEP DEP
---- --------------- ---------- ---- --------- ---------- ---------- --- ---
DEPT_NAME DEPT_LOC
--------------- ---------------
7839 King President 17-NOV-91 5000 500 500
Management New York
7566 Jones Manager 7839 02-APR-91 2975 200 200
Research Dallas
7698 Blake Manager 7839 01-MAY-91 2850 300 300
Sales Chicago
EMPL EMPL_LAST_NAME JOB_TITLE MGR HIREDATE SALARY COMMISSION DEP DEP
---- --------------- ---------- ---- --------- ---------- ---------- --- ---
DEPT_NAME DEPT_LOC
--------------- ---------------
7782 Raimi Manager 7839 09-JUN-91 2450 100 100
Accounting New York
7902 Ford Analyst 7566 03-DEC-91 3000 200 200
Research Dallas
7369 Smith Clerk 7902 17-DEC-90 800 200 200
Research Dallas
EMPL EMPL_LAST_NAME JOB_TITLE MGR HIREDATE SALARY COMMISSION DEP DEP
---- --------------- ---------- ---- --------- ---------- ---------- --- ---
DEPT_NAME DEPT_LOC
--------------- ---------------
7499 Michaels Salesman 7698 20-FEB-91 1600 300 300 300
Sales Chicago
7521 Ward Salesman 7698 22-FEB-91 1250 500 300 300
Sales Chicago
7654 Martin Salesman 7698 28-SEP-91 1250 1400 300 300
Sales Chicago
EMPL EMPL_LAST_NAME JOB_TITLE MGR HIREDATE SALARY COMMISSION DEP DEP
---- --------------- ---------- ---- --------- ---------- ---------- --- ---
DEPT_NAME DEPT_LOC
--------------- ---------------
7788 Scott Analyst 7566 09-NOV-91 3000 200 200
Research Dallas
7844 Turner Salesman 7698 08-SEP-91 1500 0 300 300
Sales Chicago
7876 Adams Clerk 7788 23-SEP-91 1100 400 400
Operations Boston
EMPL EMPL_LAST_NAME JOB_TITLE MGR HIREDATE SALARY COMMISSION DEP DEP
---- --------------- ---------- ---- --------- ---------- ---------- --- ---
DEPT_NAME DEPT_LOC
--------------- ---------------
7900 James Clerk 7698 03-DEC-91 950 300 300
Sales Chicago
7934 Miller Clerk 7782 23-JAN-92 1300 100 100
Accounting New York
14 rows selected.
SALARY DEPT_NAME
---------- ---------------
3000 Research
800 Research
2975 Research
1250 Sales
2850 Sales
5000 Management
1600 Sales
1100 Operations
1500 Sales
950 Sales
1300 Accounting
SALARY DEPT_NAME
---------- ---------------
2450 Accounting
12 rows selected.
SALARY DEPT_NAME
---------- ---------------
3000 Research
800 Research
2975 Research
1250 Sales
2850 Sales
5000 Management
1600 Sales
1100 Operations
1500 Sales
950 Sales
1300 Accounting
SALARY DEPT_NAME
---------- ---------------
2450 Accounting
12 rows selected.
SALARY DEPT_NAME
---------- ---------------
3000 Research
800 Research
2975 Research
SALARY DEPT_NAME
---------- ---------------
3000 Research
800 Research
2975 Research