your names should appear here
===========
lab problem 1
===========
DEPT_NAME SALARY
--------------- ----------
Accounting 2450
Accounting 1300
Management 5000
Operations 1100
Research 3000
Research 3000
Research 800
Research 2975
Sales 950
Sales 1500
Sales 1250
DEPT_NAME SALARY
--------------- ----------
Sales 1250
Sales 2850
Sales 1600
14 rows selected.
===========
lab problem 2
===========
DEPT_NAME SALARY
--------------- ----------
Accounting 2450
Accounting 1300
Management 5000
Operations 1100
Research 3000
Research 3000
Research 800
Research 2975
Sales 950
Sales 1500
Sales 1250
Sales 1250
Sales 2850
Sales 1600
===========
lab problem 3
===========
(remember, YOU pick the noticeably-different heading and format
for dept_name)
Department SALARY
---------- ----------
Accounting 2450
Accounting 1300
Management 5000
Operations 1100
Research 3000
Research 3000
Research 800
Research 2975
Sales 950
Sales 1500
Sales 1250
Sales 1250
Sales 2850
Sales 1600
===========
lab problem 4
===========
(remember, YOU pick the noticeably-different heading and format
for salary)
Dept
Department Salaries
---------- -----------
Accounting $2,450.00
Accounting $1,300.00
Management $5,000.00
Operations $1,100.00
Research $3,000.00
Research $3,000.00
Research $800.00
Research $2,975.00
Sales $950.00
Sales $1,500.00
Sales $1,250.00
Sales $1,250.00
Sales $2,850.00
Sales $1,600.00
===========
lab problem 5
===========
Dept
Department Salaries
---------- -----------
Accounting $2,450.00
$1,300.00
Management $5,000.00
Operations $1,100.00
Research $3,000.00
$3,000.00
$800.00
$2,975.00
Sales $950.00
$1,500.00
$1,250.00
$1,250.00
$2,850.00
$1,600.00
===========
lab problem 6
===========
Dept
Department Salaries
---------- -----------
Accounting $2,450.00
$1,300.00
********** -----------
avg $1,875.00
Management $5,000.00
********** -----------
avg $5,000.00
Operations $1,100.00
********** -----------
avg $1,100.00
Research $3,000.00
$3,000.00
$800.00
$2,975.00
********** -----------
avg $2,443.75
Sales $950.00
$1,500.00
$1,250.00
$1,250.00
$2,850.00
$1,600.00
********** -----------
avg $1,566.67
===========
lab problem 7
===========
(remember, YOU pick the top title text)
Fri Nov 19 page 1
Department Salaries and Averages
Dept
Department Salaries
---------- -----------
Accounting $2,450.00
$1,300.00
********** -----------
avg $1,875.00
Management $5,000.00
********** -----------
avg $5,000.00
Operations $1,100.00
********** -----------
avg $1,100.00
Research $3,000.00
$3,000.00
$800.00
$2,975.00
********** -----------
avg $2,443.75
Sales $950.00
$1,500.00
$1,250.00
$1,250.00
$2,850.00
$1,600.00
********** -----------
avg $1,566.67
===========
lab problem 8
===========
(for this, you can put the SQL*Plus commands and then your
query, or your query, the SQL*Plus commands, and then /. Here, I am
putting the SQL*Plus commands and then my query.)
Your query has to be at least somewhat different from that in
lab problem 1, project at least 3 different columns and/or
computations, contain at least 4 rows, and use order by to
specify the order its rows are displayed.
And, you need column commands giving each column a noticeably
different heading AND format of your choice, and at least one other
of the SQL*Plus features we discussed or from SQL Reading Packet 8
to make at least one other noticeable change.
Fri Nov 19 page 1
Job Titles - Summary
Job Avg Earliest
Title Salary Hire
--------------- ---------- ------------
Analyst $3,000.00 03-DEC-12
Clerk $1,037.50 17-DEC-12
Manager $2,758.33 02-APR-12
President $5,000.00 17-NOV-11
Sales $1,400.00 20-FEB-18
===========
lab problem 9
===========
(if you changed any other SQL*Plus defaults in lab problem 8,
be sure you restore those defaults here, also)