Table dropped.
Table created.
1 row created.
1 row created.
EMPL_LAST_NAME DEPT_NAME DEPT_LOC
--------------- --------------- ---------------
King Management New York
Jones Research Dallas
Blake Sales Chicago
Raimi Accounting New York
Ford Research Dallas
Smith Research Dallas
Michaels Sales Chicago
Ward Sales Chicago
Martin Sales Chicago
Scott Research Dallas
Turner Sales Chicago
EMPL_LAST_NAME DEPT_NAME DEPT_LOC
--------------- --------------- ---------------
Adams Operations Boston
James Sales Chicago
Miller Accounting New York
14 rows selected.
EMPL_LAST_NAME DEPT_NAME DEPT_LOC
--------------- --------------- ---------------
King Management New York
Jones Research Dallas
Blake Sales Chicago
Raimi Accounting New York
Ford Research Dallas
Smith Research Dallas
Michaels Sales Chicago
Ward Sales Chicago
Martin Sales Chicago
Scott Research Dallas
Turner Sales Chicago
EMPL_LAST_NAME DEPT_NAME DEPT_LOC
--------------- --------------- ---------------
Adams Operations Boston
James Sales Chicago
Miller Accounting New York
14 rows selected.
EMPL_LAST_NAME SALARY
--------------- ----------
Jones 2975
Blake 2850
Raimi 2450
JOB_TITLE HIREDATE
---------- ---------
Salesman 20-FEB-91
Salesman 22-FEB-91
Salesman 28-SEP-91
no rows selected
EMPL_LAST_NAME
---------------
King
Jones
Blake
Raimi
Ford
Smith
Scott
Adams
James
Miller
10 rows selected.
no rows selected
EMPL_LAST_NAME
---------------
Michaels
Ward
Martin
Turner
EMPL_LAST_NAME DEPT_NAME DEPT_LOC
--------------- --------------- ---------------
Ford Research Dallas
James Sales Chicago
Miller Accounting New York
EMPL_LAST_NAME DEPT_NAME DEPT_LOC
--------------- --------------- ---------------
Ford Research Dallas
James Sales Chicago
Miller Accounting New York
select empl_last_name, dept_num, dept_name, dept_loc
*
ERROR at line 1:
ORA-00918: column ambiguously defined
select empl_last_name, dept_num, dept_name, dept_loc
*
ERROR at line 1:
ORA-00918: column ambiguously defined
EMPL_LAST_NAME DEP DEPT_NAME DEPT_LOC
--------------- --- --------------- ---------------
Ford 200 Research Dallas
James 300 Sales Chicago
Miller 100 Accounting New York
EMPL_LAST_NAME DEP DEPT_NAME DEPT_LOC
--------------- --- --------------- ---------------
Ford 200 Research Dallas
James 300 Sales Chicago
Miller 100 Accounting New York
EMPL EMPL_LAST_NAME JOB_TITLE MGR HIREDATE SALARY COMMISSION DEP
---- --------------- ---------- ---- --------- ---------- ---------- ---
7499 Michaels Salesman 7698 20-FEB-91 1600 300 300
7844 Turner Salesman 7698 08-SEP-91 1500 0 300
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
7782 Raimi Manager 7839 09-JUN-91 2450 100
7902 Ford Analyst 7566 03-DEC-91 3000 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
7844 Turner Salesman 7698 08-SEP-91 1500 0 300
10 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
7782 Raimi Manager 7839 09-JUN-91 2450 100
7902 Ford Analyst 7566 03-DEC-91 3000 200
7654 Martin Salesman 7698 28-SEP-91 1250 1400 300
7788 Scott Analyst 7566 09-NOV-91 3000 200
7844 Turner Salesman 7698 08-SEP-91 1500 0 300
8 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
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
7788 Scott Analyst 7566 09-NOV-91 3000 200
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
10 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
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
7788 Scott Analyst 7566 09-NOV-91 3000 200
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
10 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
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
7788 Scott Analyst 7566 09-NOV-91 3000 200
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
10 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
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
7788 Scott Analyst 7566 09-NOV-91 3000 200
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
10 rows selected.
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
7876 Adams Clerk 7788 23-SEP-91 1100 400
7934 Miller Clerk 7782 23-JAN-92 1300 100
6 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
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
7788 Scott Analyst 7566 09-NOV-91 3000 200
7900 James Clerk 7698 03-DEC-91 950 300
8 rows selected.
EMPL EMPL_LAST_NAME JOB_TITLE MGR HIREDATE SALARY COMMISSION DEP
---- --------------- ---------- ---- --------- ---------- ---------- ---
7839 King President 17-NOV-91 5000 500
7369 Smith Clerk 7902 17-DEC-90 800 200
7499 Michaels Salesman 7698 20-FEB-91 1600 300 300
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
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
7844 Turner Salesman 7698 08-SEP-91 1500 0 300
EMPL EMPL_LAST_NAME JOB_TITLE MGR HIREDATE SALARY COMMISSION DEP
---- --------------- ---------- ---- --------- ---------- ---------- ---
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.
EMPL EMPL_LAST_NAME JOB_TITLE MGR HIREDATE SALARY COMMISSION DEP
---- --------------- ---------- ---- --------- ---------- ---------- ---
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
EMPL EMPL_LAST_NAME JOB_TITLE MGR HIREDATE SALARY COMMISSION DEP
---- --------------- ---------- ---- --------- ---------- ---------- ---
7698 Blake Manager 7839 01-MAY-91 2850 300
7499 Michaels Salesman 7698 20-FEB-91 1600 300 300
EMPL EMPL_LAST_NAME JOB_TITLE MGR HIREDATE SALARY COMMISSION DEP
---- --------------- ---------- ---- --------- ---------- ---------- ---
7698 Blake Manager 7839 01-MAY-91 2850 300
7876 Adams Clerk 7788 23-SEP-91 1100 400
EMPL EMPL_LAST_NAME JOB_TITLE MGR HIREDATE SALARY COMMISSION DEP
---- --------------- ---------- ---- --------- ---------- ---------- ---
7839 King President 17-NOV-91 5000 500
7698 Blake Manager 7839 01-MAY-91 2850 300
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
7900 James Clerk 7698 03-DEC-91 950 300
7934 Miller Clerk 7782 23-JAN-92 1300 100
7 rows selected.
EMPL EMPL_LAST_NAME JOB_TITLE MGR HIREDATE SALARY COMMISSION DEP
---- --------------- ---------- ---- --------- ---------- ---------- ---
7499 Michaels Salesman 7698 20-FEB-91 1600 300 300
ORDER CUST_I EMPL ORDER_MAD ORDER_FIL ORDER_TOTAL
----- ------ ---- --------- --------- -----------
00002 345678 7654 22-SEP-10 99.97
ORDER CUST_I EMPL ORDER_MAD ORDER_FIL ORDER_TOTAL
----- ------ ---- --------- --------- -----------
00001 123456 7521 02-FEB-04 04-FEB-04 58.99
00002 345678 7654 22-SEP-10 99.97
ORDER CUST_I EMPL ORDER_MAD ORDER_FIL ORDER_TOTAL
----- ------ ---- --------- --------- -----------
00001 123456 7521 02-FEB-04 04-FEB-04 58.99
00002 345678 7654 22-SEP-10 99.97
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
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
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
7654 Martin Salesman 7698 28-SEP-91 1250 1400 300
7788 Scott Analyst 7566 09-NOV-91 3000 200
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
EMPL EMPL_LAST_NAME JOB_TITLE MGR HIREDATE SALARY COMMISSION DEP
---- --------------- ---------- ---- --------- ---------- ---------- ---
7934 Miller Clerk 7782 23-JAN-92 1300 100
12 rows selected.
where salary like _6__
*
ERROR at line 3:
ORA-00911: invalid character
EMPL_LAST_NAME SALARY*2
--------------- ----------
King 10000
Jones 5950
Blake 5700
Raimi 4900
Ford 6000
Smith 1600
Michaels 3200
Ward 2500
Martin 2500
Scott 6000
Turner 3000
EMPL_LAST_NAME SALARY*2
--------------- ----------
Adams 2200
James 1900
Miller 2600
14 rows selected.
Last Name double salary
--------------- -------------
King 10000
Jones 5950
Blake 5700
Raimi 4900
Ford 6000
Smith 1600
Michaels 3200
Ward 2500
Martin 2500
Scott 6000
Turner 3000
Last Name double salary
--------------- -------------
Adams 2200
James 1900
Miller 2600
14 rows selected.
LASTNAME TWICECURRENT
--------------- ------------
King 10000
Jones 5950
Blake 5700
Raimi 4900
Ford 6000
Smith 1600
Michaels 3200
Ward 2500
Martin 2500
Scott 6000
Turner 3000
LASTNAME TWICECURRENT
--------------- ------------
Adams 2200
James 1900
Miller 2600
14 rows selected.
combined gross
--------------
1900
1750
2650
1500
combined gross
--------------
14 rows selected.
EMPL_LAST_NAME GROSS
--------------- ----------
King
Jones
Blake
Raimi
Ford
Smith
Michaels 1900
Ward 1750
Martin 2650
Scott
Turner 1500
EMPL_LAST_NAME GROSS
--------------- ----------
Adams
James
Miller
14 rows selected.
DEP EMPL_LAST_NAME
--- ---------------
500 King
200 Jones
300 Blake
100 Raimi
200 Ford
200 Smith
300 Michaels
300 Ward
300 Martin
200 Scott
300 Turner
DEP EMPL_LAST_NAME
--- ---------------
400 Adams
300 James
100 Miller
14 rows selected.
DEP EMPL_LAST_NAME
--- ---------------
500 King
200 Jones
300 Blake
100 Raimi
200 Ford
200 Smith
300 Michaels
300 Ward
300 Martin
200 Scott
300 Turner
DEP EMPL_LAST_NAME
--- ---------------
400 Adams
300 James
100 Miller
14 rows selected.
select dept.dept_num, empl_last_name
*
ERROR at line 1:
ORA-00904: "DEPT"."DEPT_NUM": invalid identifier
select dept.dept_num, empl_last_name
*
ERROR at line 1:
ORA-00904: "DEPT"."DEPT_NUM": invalid identifier
DEP EMPL_LAST_NAME
--- ---------------
500 King
200 Jones
300 Blake
100 Raimi
200 Ford
200 Smith
300 Michaels
300 Ward
300 Martin
200 Scott
300 Turner
DEP EMPL_LAST_NAME
--- ---------------
400 Adams
300 James
100 Miller
14 rows selected.
DEP EMPL_LAST_NAME
--- ---------------
500 King
200 Jones
300 Blake
100 Raimi
200 Ford
200 Smith
300 Michaels
300 Ward
300 Martin
200 Scott
300 Turner
DEP EMPL_LAST_NAME
--- ---------------
400 Adams
300 James
100 Miller
14 rows selected.
CUST_LNAME EMPL_LAST_NAME DEPT_LOC
-------------------- --------------- ---------------
Firstly Michaels Chicago
Secondly Martin Chicago
Thirdly Michaels Chicago
CUST_LNAME EMPL_LAST_NAME DEPT_LOC
-------------------- --------------- ---------------
Thirdly Michaels Chicago
Secondly Martin Chicago
Firstly Michaels Chicago
CUST_LNAME EMPL_LAST_NAME DEPT_LOC
-------------------- --------------- ---------------
Firstly Michaels Chicago
Thirdly Michaels Chicago
CUST_LNAME EMPL_LAST_NAME DEPT_LOC
-------------------- --------------- ---------------
Firstly Michaels Chicago
Thirdly Michaels Chicago
CUST_LNAME EMPL_LAST_NAME DEPT_LOC DEP
-------------------- --------------- --------------- ---
Firstly Michaels Chicago 300
Secondly Martin Chicago 300
Thirdly Michaels Chicago 300
CUST_LNAME EMPL_LAST_NAME DEPT_LOC DEP
-------------------- --------------- --------------- ---
Thirdly Michaels Chicago 300
Secondly Martin Chicago 300
Firstly Michaels Chicago 300
EMPLOYEE MANAGER
--------------- ---------------
Raimi King
Blake King
Jones King
Scott Jones
Ford Jones
James Blake
Turner Blake
Martin Blake
Ward Blake
Michaels Blake
Miller Raimi
EMPLOYEE MANAGER
--------------- ---------------
Smith Ford
Adams Scott
13 rows selected.
EMPLOYEE MANAGER
--------------- ---------------
Raimi King
Blake King
Jones King
Scott Jones
Ford Jones
James Blake
Turner Blake
Martin Blake
Ward Blake
Michaels Blake
Miller Raimi
EMPLOYEE MANAGER
--------------- ---------------
Smith Ford
Adams Scott
13 rows selected.
EMPL_LAST_NAME JOB_TITLE SALARY
--------------- ---------- ----------
Jones Manager 2975
Blake Manager 2850
Raimi Manager 2450
Ford Analyst 3000
Scott Analyst 3000
EMPL_LAST_NAME JOB_TITLE SALARY
--------------- ---------- ----------
Jones Manager 2975
Blake Manager 2850
Raimi Manager 2450
Ford Analyst 3000
Scott Analyst 3000
EMPL_LAST_NAME JOB_TITLE
--------------- ----------
King President
Smith Clerk
Michaels Salesman
Ward Salesman
Martin Salesman
Turner Salesman
Adams Clerk
James Clerk
Miller Clerk
9 rows selected.
AVG(SALARY) AVG(COMMISSION) MIN(SALARY) MAX(SALARY) SUM(SALARY) COUNT(SALARY)
----------- --------------- ----------- ----------- ----------- -------------
COUNT(MGR) MIN(HIRED COUNT(COMMISSION)
---------- --------- -----------------
2073.21429 550 800 5000 29025 14
13 17-DEC-90 4
Average Salary Average Commission MINIMUM MAXIMUM SUM
-------------- ------------------ ---------- ---------- ----------
number of employees
-------------------
2073.21429 550 800 5000 29025
14
Avg Comm Min Comm Max Comm Comm Sum How many have comm
---------- ---------- ---------- ---------- ------------------
550 0 1400 2200 4
COUNT(SALARY) COUNT(COMMISSION) COUNT(MGR)
------------- ----------------- ----------
14 4 13
COUNT(*) COUNT(COMMISSION) COUNT(SALARY) COUNT(MGR)
---------- ----------------- ------------- ----------
14 4 14 13
Number of Employees
-------------------
14
Number of Managers
------------------
3
COUNT(*) AVG(SALARY)
---------- -----------
4 1037.5
Enter value for job_ttl: 'Manager'
old 3: where job_title = &job_ttl
new 3: where job_title = 'Manager'
SALARY
----------
2975
2850
2450
Enter value for job_ttl: 'Manager' or 1 = 1
old 3: where job_title = &job_ttl
new 3: where job_title = 'Manager' or 1 = 1
SALARY
----------
5000
2975
2850
2450
3000
800
1600
1250
1250
3000
1500
SALARY
----------
1100
950
1300
14 rows selected.