|
melpriciot
Starting Member
1 Posts |
 Posted - 01/05/2013 : 07:21:21
|
"Create a view named "premiums" that should contain the
name of the employees and a premium column.
Compute the values for the premium column for each
employee as follows:
(absolute_value(
maximum(
number_of_employees_working_on_job_of_employees_manager)
- number_of_employees_working_on_their_own_job)
+ 10) * 20.
The view should contain the following columns:
"first_name", "last_name", "premium"."
"Create a table named "own_jobs" that should contain
the following columns:
"id", string with 10 characters as a maximum length, is the primary key;
"title", string with 35 characters as a maximum length;
"num_of_emps", number, its default value is 0;
"since", of type date.
Please check, the values of the "num_of_emps" column
cannot be a negative number."
"Insert data into the new "own_jobs" table from the HR schema.
The "id" and "title" columns should hold the same data as
the "job_id" and "job_title" columns in the HR.JOBS table.
The "num_of_emps" column should contain the headcount of
those employees who are working on the given job.
The "since" column should contain the earliest "hire_date"
on the given job."
"Update the "own_jobs" table: concatenate the value of "id"
column to value of "title" column in those rows/records where
total length of title and id together is not longer than 35
characters. Format of new title: "title_of_job (id_of_job)"." |
|
please can someone help me execute this query
