your names should appear here
===========
lab problem 1
===========
View dropped.
View created.
===========
lab problem 2
===========
EMPL_LAST_NAME SALARY
--------------- ----------
King 5000
Jones 2975
Blake 2850
Raimi 2450
Ford 3000
Smith 800
Michaels 1600
Ward 1250
Martin 1250
Scott 3000
Turner 1500
EMPL_LAST_NAME SALARY
--------------- ----------
Adams 1100
James 950
Miller 1300
14 rows selected.
===========
lab problem 3
===========
MAX(SALARY)
-----------
5000
===========
lab problem 4
===========
View dropped.
View created.
===========
lab problem 5
===========
JOB_TITLE EARLIEST_
---------- ---------
Manager 02-APR-12
Analyst 03-DEC-12
Clerk 17-DEC-12
President 17-NOV-11
Sales 20-FEB-18
===========
lab problem 6
===========
MAX(EARLI
---------
20-FEB-18
===========
lab problem 7
===========
View dropped.
View created.
===========
lab problem 8
===========
CUSTOMER REPD_BY DEPT_LOC
------------------------------------- --------------- ---------------
Firstly, First Michaels Chicago
Secondly, Second Martin Chicago
Thirdly, Third Michaels Chicago
===========
lab problem 9
===========
This should print a description of the view you decided to create,
one at least somewhat different from those already created in this
lab exercise, that you think would be useful or interesting to have.
employees, departments, and/or customers that you think you can
For example:
We are creating a view earliest_dept_hire, that shows, for each
department, the earliest hiredate for someone in that department.
(and here you should see that this view is dropped and created)
For example:
View dropped.
View created.
(then you should write a query projecting all of the columns of all
of the rows of your view)
for example:
DEPT_NAME EARLIEST_
--------------- ---------
Research 02-APR-12
Accounting 09-JUN-12
Management 17-NOV-11
Sales 01-MAY-13
Operations 23-SEP-18
(then you should write another query using your new view, doing
something more than the previous query)
for example:
DEPT_NAME EARLIEST_ DEPT_LOC
--------------- --------- ---------------
Management 17-NOV-11 New York
Research 02-APR-12 Dallas
Accounting 09-JUN-12 New York
Sales 01-MAY-13 Chicago
Operations 23-SEP-18 Boston