Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
melpriciot
Starting Member
1 Post |
Posted - 2013-01-05 : 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)"." |
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-01-06 : 10:07:19
|
sounds like an assignment questioncan we see what you tried yet?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|