Employee
EMPL_NUM 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
7782 Raimi Manager 7839 09-JUN-91 2450 100
7902 Ford Analyst 7566 03-DEC-91 3000 200
7369 Smith Clerk 7902 17-DEC-90 800 200
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
7788 Scott Analyst 7566 09-NOV-91 3000 200
Employee
EMPL_NUM Last Name JOB_TITLE MGR HIREDATE SALARY COMMISSION DEP
-------- ------------------------- ---------- ---- --------- ---------- ---------- ---
7844 Turner Salesman 7698 08-SEP-91 1500 0 300
7876 Adams Clerk 7788 23-SEP-91 1100 400
7900 James Clerk 7698 03-DEC-91 950 300
7934 Miller Clerk 7782 23-JAN-92 1300 100
14 rows selected.
Employee
EMPL_NUM 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
7782 Raimi Manager 7839 09-JUN-91 2450 100
7902 Ford Analyst 7566 03-DEC-91 3000 200
7369 Smith Clerk 7902 17-DEC-90 800 200
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
7788 Scott Analyst 7566 09-NOV-91 3000 200
Employee
EMPL_NUM Name JOB_TITLE MGR HIREDATE SALARY COMMISSION DEP
-------- ------------------------- ---------- ---- --------- ---------- ---------- ---
7844 Turner Salesman 7698 08-SEP-91 1500 0 300
7876 Adams Clerk 7788 23-SEP-91 1100 400
7900 James Clerk 7698 03-DEC-91 950 300
7934 Miller Clerk 7782 23-JAN-92 1300 100
14 rows selected.
SP2-0158: unknown COLUMN option "Name"
Employee
EMPL_NUM 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
7782 Raimi Manager 7839 09-JUN-91 2450 100
7902 Ford Analyst 7566 03-DEC-91 3000 200
7369 Smith Clerk 7902 17-DEC-90 800 200
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
7788 Scott Analyst 7566 09-NOV-91 3000 200
Employee
EMPL_NUM Last Name JOB_TITLE MGR HIREDATE SALARY COMMISSION DEP
-------- ------------------------- ---------- ---- --------- ---------- ---------- ---
7844 Turner Salesman 7698 08-SEP-91 1500 0 300
7876 Adams Clerk 7788 23-SEP-91 1100 400
7900 James Clerk 7698 03-DEC-91 950 300
7934 Miller Clerk 7782 23-JAN-92 1300 100
14 rows selected.
Em
EMPL_NUM La JOB_TITLE MGR HIREDATE SALARY COMMISSION DEP
-------- -- ---------- ---- --------- ---------- ---------- ---
7839 Ki President 17-NOV-91 5000 500
ng
7566 Jo Manager 7839 02-APR-91 2975 200
ne
s
7698 Bl Manager 7839 01-MAY-91 2850 300
ak
e
Em
EMPL_NUM La JOB_TITLE MGR HIREDATE SALARY COMMISSION DEP
-------- -- ---------- ---- --------- ---------- ---------- ---
7782 Ra Manager 7839 09-JUN-91 2450 100
im
i
7902 Fo Analyst 7566 03-DEC-91 3000 200
rd
7369 Sm Clerk 7902 17-DEC-90 800 200
it
Em
EMPL_NUM La JOB_TITLE MGR HIREDATE SALARY COMMISSION DEP
-------- -- ---------- ---- --------- ---------- ---------- ---
h
7499 Mi Salesman 7698 20-FEB-91 1600 300 300
ch
ae
ls
7521 Wa Salesman 7698 22-FEB-91 1250 500 300
rd
Em
EMPL_NUM La JOB_TITLE MGR HIREDATE SALARY COMMISSION DEP
-------- -- ---------- ---- --------- ---------- ---------- ---
7654 Ma Salesman 7698 28-SEP-91 1250 1400 300
rt
in
7788 Sc Analyst 7566 09-NOV-91 3000 200
ot
t
7844 Tu Salesman 7698 08-SEP-91 1500 0 300
rn
Em
EMPL_NUM La JOB_TITLE MGR HIREDATE SALARY COMMISSION DEP
-------- -- ---------- ---- --------- ---------- ---------- ---
er
7876 Ad Clerk 7788 23-SEP-91 1100 400
am
s
7900 Ja Clerk 7698 03-DEC-91 950 300
me
s
Em
EMPL_NUM La JOB_TITLE MGR HIREDATE SALARY COMMISSION DEP
-------- -- ---------- ---- --------- ---------- ---------- ---
7934 Mi Clerk 7782 23-JAN-92 1300 100
ll
er
14 rows selected.
Em
EMPL_NUM La JOB_TITLE MGR HIREDATE SALARY COMMISSION DEP
-------- -- ---------- ---- --------- ---------- ---------- ---
7839 Ki President 17-NOV-91 5000 500
7566 Jo Manager 7839 02-APR-91 2975 200
7698 Bl Manager 7839 01-MAY-91 2850 300
7782 Ra Manager 7839 09-JUN-91 2450 100
7902 Fo Analyst 7566 03-DEC-91 3000 200
7369 Sm Clerk 7902 17-DEC-90 800 200
7499 Mi Salesman 7698 20-FEB-91 1600 300 300
7521 Wa Salesman 7698 22-FEB-91 1250 500 300
7654 Ma Salesman 7698 28-SEP-91 1250 1400 300
7788 Sc Analyst 7566 09-NOV-91 3000 200
Em
EMPL_NUM La JOB_TITLE MGR HIREDATE SALARY COMMISSION DEP
-------- -- ---------- ---- --------- ---------- ---------- ---
7844 Tu Salesman 7698 08-SEP-91 1500 0 300
7876 Ad Clerk 7788 23-SEP-91 1100 400
7900 Ja Clerk 7698 03-DEC-91 950 300
7934 Mi Clerk 7782 23-JAN-92 1300 100
14 rows selected.
1 row created.
1 row created.
PTG_TIT PTR
------- ---
Waterli 104
lies
Yet fou 104
r more
PTG_TIT PTR
------- ---
Waterli 104
lies
Yet 104
four
more
PTG_TIT PTR
------- ---
Waterli 104
lies
Yet 104
four
more
PTG_TIT PTR
------- ---
Waterli 104
lies
Yet 104
four
more
PTG_TIT PTR
------- ---
Waterli 104
lies
Yet 104
four
more
PTG_TIT PTR
------- ---
Waterli 104
lies
Yet 104
four
more
PTG_TIT PTR
------- ---
Waterli 104
lies
Yet 104
four
more
Employee
Last Name DEP Salary
---------------- --- ------
King 500 5000
Jones 200 2975
Blake 300 2850
Raimi 100 2450
Ford 200 3000
Smith 200 800
Michaels 300 1600
Ward 300 1250
Martin 300 1250
Scott 200 3000
Employee
Last Name DEP Salary
---------------- --- ------
Turner 300 1500
Adams 400 1100
James 300 950
Miller 100 1300
14 rows selected.
Employee
EMPL_NUM Last Name JOB_TITLE MGR HIREDATE Salary COMMISSION Dept#
-------- ---------------- ---------- ---- --------------- ------ ---------- -----
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
7782 Raimi Manager 7839 09-JUN-91 2450 100
7902 Ford Analyst 7566 03-DEC-91 3000 200
7369 Smith Clerk 7902 17-DEC-90 800 200
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
7788 Scott Analyst 7566 09-NOV-91 3000 200
Employee
EMPL_NUM Last Name JOB_TITLE MGR HIREDATE Salary COMMISSION Dept#
-------- ---------------- ---------- ---- --------------- ------ ---------- -----
7844 Turner Salesman 7698 08-SEP-91 1500 0 300
7876 Adams Clerk 7788 23-SEP-91 1100 400
7900 James Clerk 7698 03-DEC-91 950 300
7934 Miller Clerk 7782 23-JAN-92 1300 100
14 rows selected.
Dept# DEPT_NAME DEPT_LOC
----- --------------- ---------------
100 Accounting New York
200 Research Dallas
300 Sales Chicago
400 Operations Boston
500 Management New York
Dept# DEPT_NAME DEPT_LOC
----- --------------- ---------------
100 Accounting New York
200 Research Dallas
300 Sales Chicago
400 Operations Boston
500 Management New York
Dept# DEPT_NAME DEPT_LOC
----- --------------- ---------------
100 Accounting New York
200 Research Dallas
300 Sales Chicago
400 Operations Boston
500 Management New York
Dept# DEPT_NAME DEPT_LOC
----- --------------- ---------------
100 Accounting New York
200 Research Dallas
300 Sales Chicago
400 Operations Boston
500 Management New York
Dept# DEPT_NAME DEPT_LOC
----- --------------- ---------------
100 Accounting New York
200 Research Dallas
300 Sales Chicago
400 Operations Boston
500 Management New York
Dept# DEPT_NAME DEPT_LOC
----- --------------- ---------------
100 Accounting New York
200 Research Dallas
300 Sales Chicago
400 Operations Boston
500 Management New York
Dept# DEPT_NAME DEPT_LOC
----- --------------- ---------------
100 Accounting New York
200 Research Dallas
300 Sales Chicago
400 Operations Boston
500 Management New York
Dept# DEPT_NAME DEPT_LOC
----- --------------- ---------------
100 Accounting New York
200 Research Dallas
300 Sales Chicago
400 Operations Boston
500 Management New York
Employee
Last Name Commission
---------------- ----------
Michaels $300.00
Ward $500.00
Martin $1,400.00
Turner $.00
Employee
Last Name Commission
---------------- ----------
Michaels $300.00
Ward $500.00
Martin $1,400.00
Turner $0.00
Employee
Last Name Commission
---------------- ----------
Michaels $0,300.00
Ward $0,500.00
Martin $1,400.00
Turner $0,000.00
Employee
Last Name Salary Commission
---------------- ----------- -----------
Michaels $1,600.00 $300.00
Ward $1,250.00 $500.00
Martin $1,250.00 $1,400.00
Turner $1,500.00 $0.00
DEPT_NAME AVG(SALARY)
--------------- -----------
Research 2443.75
Accounting 1875
Management 5000
Sales 1566.66667
Operations 1100
DEPT_NAME Dept Avg
--------------- -----------
Research $2,443.75
Accounting $1,875.00
Management $5,000.00
Sales $1,566.67
Operations $1,100.00
JOB_TITLE Dept Avg
---------- -----------
Manager $2,758.33
Analyst $3,000.00
Clerk $1,037.50
President $5,000.00
Salesman $1,400.00
View dropped.
View created.
Dept Name Dept Avg
--------------- -----------
Accounting $1,875.00
Management $5,000.00
Operations $1,100.00
Research $2,443.75
Sales $1,566.67
Dept Name Dept Avg
--------------- -----------
Management $5,000.00
Research $2,443.75
Accounting $1,875.00
Sales $1,566.67
Operations $1,100.00
Employee
Dept# Last Name Salary
----- ---------------- -----------
100 Miller $1,300.00
100 Raimi $2,450.00
200 Scott $3,000.00
200 Jones $2,975.00
200 Ford $3,000.00
200 Smith $800.00
300 Martin $1,250.00
300 Ward $1,250.00
300 Blake $2,850.00
300 Michaels $1,600.00
Employee
Dept# Last Name Salary
----- ---------------- -----------
300 James $950.00
300 Turner $1,500.00
400 Adams $1,100.00
500 King $5,000.00
14 rows selected.
Employee
Dept Last Name Salary
---- ---------------- -----------
100 Miller $1,300.00
100 Raimi $2,450.00
200 Scott $3,000.00
200 Jones $2,975.00
200 Ford $3,000.00
200 Smith $800.00
300 Martin $1,250.00
300 Ward $1,250.00
300 Blake $2,850.00
300 Michaels $1,600.00
Employee
Dept Last Name Salary
---- ---------------- -----------
300 James $950.00
300 Turner $1,500.00
400 Adams $1,100.00
500 King $5,000.00
14 rows selected.
Employee
Dept Last Name Salary
---- ---------------- -----------
100 Miller $1,300.00
Raimi $2,450.00
200 Scott $3,000.00
Jones $2,975.00
Ford $3,000.00
Smith $800.00
300 Martin $1,250.00
Ward $1,250.00
Blake $2,850.00
Michaels $1,600.00
Employee
Dept Last Name Salary
---- ---------------- -----------
300 James $950.00
Turner $1,500.00
400 Adams $1,100.00
500 King $5,000.00
14 rows selected.
Employee
Dept Last Name Salary
---- ---------------- -----------
100 Miller $1,300.00
Raimi $2,450.00
200 Scott $3,000.00
Jones $2,975.00
Ford $3,000.00
Smith $800.00
300 Martin $1,250.00
Ward $1,250.00
Employee
Dept Last Name Salary
---- ---------------- -----------
300 Blake $2,850.00
Michaels $1,600.00
James $950.00
Turner $1,500.00
400 Adams $1,100.00
500 King $5,000.00
14 rows selected.
Employee
Dept Mgr Last Name Salary
---- ---- ---------------- -----------
100 7782 Miller $1,300.00
7839 Raimi $2,450.00
200 7566 Scott $3,000.00
7566 Ford $3,000.00
7839 Jones $2,975.00
7902 Smith $800.00
300 7698 Michaels $1,600.00
7698 James $950.00
Employee
Dept Mgr Last Name Salary
---- ---- ---------------- -----------
300 7698 Turner $1,500.00
7698 Ward $1,250.00
7698 Martin $1,250.00
7839 Blake $2,850.00
400 7788 Adams $1,100.00
500 King $5,000.00
14 rows selected.
Employee
Dept Mgr Last Name Salary
---- ---- ---------------- -----------
100 7782 Miller $1,300.00
7839 Raimi $2,450.00
200 7566 Scott $3,000.00
Ford $3,000.00
7839 Jones $2,975.00
7902 Smith $800.00
Employee
Dept Mgr Last Name Salary
---- ---- ---------------- -----------
300 7698 Michaels $1,600.00
James $950.00
Turner $1,500.00
Ward $1,250.00
Martin $1,250.00
7839 Blake $2,850.00
400 7788 Adams $1,100.00
Employee
Dept Mgr Last Name Salary
---- ---- ---------------- -----------
500 King $5,000.00
14 rows selected.
Employee
Dept Mgr Last Name Salary
---- ---- ---------------- -----------
100 7782 Miller $1,300.00
7839 Raimi $2,450.00
200 7566 Scott $3,000.00
Ford $3,000.00
7839 Jones $2,975.00
7902 Smith $800.00
300 7698 Michaels $1,600.00
James $950.00
Employee
Dept Mgr Last Name Salary
---- ---- ---------------- -----------
300 7698 Turner $1,500.00
Ward $1,250.00
Martin $1,250.00
7839 Blake $2,850.00
400 7788 Adams $1,100.00
500 King $5,000.00
14 rows selected.
Employee
Dept Mgr Last Name Salary
---- ---- ---------------- -----------
100 7782 Miller $1,300.00
7839 Raimi $2,450.00
200 7566 Scott $3,000.00
Ford $3,000.00
Employee
Dept Mgr Last Name Salary
---- ---- ---------------- -----------
200 7839 Jones $2,975.00
7902 Smith $800.00
300 7698 Michaels $1,600.00
James $950.00
Employee
Dept Mgr Last Name Salary
---- ---- ---------------- -----------
300 7698 Turner $1,500.00
Ward $1,250.00
Martin $1,250.00
7839 Blake $2,850.00
400 7788 Adams $1,100.00
Employee
Dept Mgr Last Name Salary
---- ---- ---------------- -----------
500 King $5,000.00
14 rows selected.
Employee
Dept Mgr Last Name Salary
---- ---- ---------------- -----------
100 7782 Miller $1,300.00
7839 Raimi $2,450.00
200 7566 Scott $3,000.00
Ford $3,000.00
Employee
Dept Mgr Last Name Salary
---- ---- ---------------- -----------
200 7839 Jones $2,975.00
7902 Smith $800.00
Employee
Dept Mgr Last Name Salary
---- ---- ---------------- -----------
300 7698 Michaels $1,600.00
James $950.00
Turner $1,500.00
Ward $1,250.00
Martin $1,250.00
7839 Blake $2,850.00
Employee
Dept Mgr Last Name Salary
---- ---- ---------------- -----------
400 7788 Adams $1,100.00
500 King $5,000.00
14 rows selected.
Employee
Dept Mgr Last Name Salary
---- ---- ---------------- -----------
100 7782 Miller $1,300.00
7839 Raimi $2,450.00
**** **** -----------
avg $1,875.00
mini $1,300.00
maxi $2,450.00
200 7566 Scott $3,000.00
Ford $3,000.00
7839 Jones $2,975.00
Employee
Dept Mgr Last Name Salary
---- ---- ---------------- -----------
200 7902 Smith $800.00
**** **** -----------
avg $2,443.75
mini $800.00
maxi $3,000.00
300 7698 Michaels $1,600.00
James $950.00
Turner $1,500.00
Ward $1,250.00
Employee
Dept Mgr Last Name Salary
---- ---- ---------------- -----------
300 7698 Martin $1,250.00
7839 Blake $2,850.00
**** **** -----------
avg $1,566.67
mini $950.00
maxi $2,850.00
400 7788 Adams $1,100.00
**** **** -----------
avg $1,100.00
Employee
Dept Mgr Last Name Salary
---- ---- ---------------- -----------
mini $1,100.00
maxi $1,100.00
500 King $5,000.00
**** **** -----------
avg $5,000.00
mini $5,000.00
maxi $5,000.00
14 rows selected.
COMPUTE avg LABEL 'avg' minimum LABEL 'minimum' maximum LABEL 'maximum' OF salary ON dept_num
break on empl nodup
on dept_num skip 1 nodup
on mgr nodup
Employee
Dept Mgr Last Name Salary
---- ---- ---------------- -----------
100 7782 Miller $1,300.00
7839 Raimi $2,450.00
**** **** ---------------- -----------
avg $1,875.00
coun 2
mini $1,300.00
maxi $2,450.00
200 7566 Scott $3,000.00
Ford $3,000.00
Employee
Dept Mgr Last Name Salary
---- ---- ---------------- -----------
200 7839 Jones $2,975.00
7902 Smith $800.00
**** **** ---------------- -----------
avg $2,443.75
coun 4
mini $800.00
maxi $3,000.00
300 7698 Michaels $1,600.00
James $950.00
Employee
Dept Mgr Last Name Salary
---- ---- ---------------- -----------
300 7698 Turner $1,500.00
Ward $1,250.00
Martin $1,250.00
7839 Blake $2,850.00
**** **** ---------------- -----------
avg $1,566.67
coun 6
mini $950.00
maxi $2,850.00
Employee
Dept Mgr Last Name Salary
---- ---- ---------------- -----------
400 7788 Adams $1,100.00
**** **** ---------------- -----------
avg $1,100.00
coun 1
mini $1,100.00
maxi $1,100.00
500 King $5,000.00
**** **** ---------------- -----------
avg $5,000.00
Employee
Dept Mgr Last Name Salary
---- ---- ---------------- -----------
coun 1
mini $5,000.00
maxi $5,000.00
14 rows selected.
COMPUTE avg LABEL 'avg' minimum LABEL 'minimum' maximum LABEL 'maximum' OF salary ON dept_num
COMPUTE count LABEL 'count' OF empl_last_name ON dept_num
Employee
Dept Mgr Last Name Salary
---- ---- ---------------- -----------
100 7782 Miller $1,300.00
7839 Raimi $2,450.00
**** **** ---------------- -----------
coun 2 2
200 7566 Scott $3,000.00
Ford $3,000.00
7839 Jones $2,975.00
7902 Smith $800.00
**** **** ---------------- -----------
Employee
Dept Mgr Last Name Salary
---- ---- ---------------- -----------
coun 4 4
300 7698 Michaels $1,600.00
James $950.00
Turner $1,500.00
Ward $1,250.00
Martin $1,250.00
7839 Blake $2,850.00
**** **** ---------------- -----------
coun 6 6
Employee
Dept Mgr Last Name Salary
---- ---- ---------------- -----------
400 7788 Adams $1,100.00
**** **** ---------------- -----------
coun 1 1
500 King $5,000.00
**** **** ---------------- -----------
coun 1 1
14 rows selected.
COMPUTE count LABEL 'count' OF empl_last_name ON dept_num
COMPUTE count LABEL 'count' OF salary ON dept_num
Employee
Dept Last Name Salary
----- ---------------- -----------
100 Miller $1,300.00
Raimi $2,450.00
***** ---------------- -----------
count 2
total $3,750.00
200 Scott $3,000.00
Jones $2,975.00
Ford $3,000.00
Smith $800.00
Employee
Dept Last Name Salary
----- ---------------- -----------
***** ---------------- -----------
count 4
total $9,775.00
300 Martin $1,250.00
Ward $1,250.00
Blake $2,850.00
Michaels $1,600.00
James $950.00
Turner $1,500.00
Employee
Dept Last Name Salary
----- ---------------- -----------
***** ---------------- -----------
count 6
total $9,400.00
400 Adams $1,100.00
***** ---------------- -----------
count 1
total $1,100.00
500 King $5,000.00
Employee
Dept Last Name Salary
----- ---------------- -----------
***** ---------------- -----------
count 1
total $5,000.00
14 rows selected.
Dept EMPL_NU
------- -------
100 7934
7782
******* -------
count 2
200 7788
7566
7902
7369
******* -------
count 4
300 7654
7521
7698
7499
7900
7844
******* -------
count 6
400 7876
******* -------
count 1
500 7839
******* -------
count 1
-------
Total 14
14 rows selected.
ttitle OFF and is the following 30 characters:
Beautiful|Three Line|Top Title
btitle OFF and is the following 30 characters:
Gorgeous Two-line|Bottom Title
Wed Nov 17 page 1
Beautiful
Three Line
Top Title
Dept EMPL_NU
------- -------
100 7934
7782
******* -------
count 2
200 7788
7566
7902
7369
******* -------
count 4
300 7654
7521
7698
7499
7900
7844
******* -------
count 6
400 7876
******* -------
count 1
500 7839
******* -------
count 1
-------
Total 14
Gorgeous Two-line
Bottom Title
14 rows selected.