Question: 6. Design and execute a SQL query that correctly uses the CASE function and Employees table to display FIRST_NAME, the hire date is going to

6. Design and execute a SQL query that correctly uses the

6. Design and execute a SQL query that correctly uses the CASE function and Employees table to display FIRST_NAME, the hire date is going to have four months added to it which the first Monday following the day and name the column as Next Evaluation day". A new column named as Salary Updates using a column job_id, with the case expression as follows; If the job_id is AD_VP', display 17000 If the job_id is 'AD_ASST', display 4400 If the job_id is 'AC_MGR', display 12000 Otherwise, display 20000 Restrict the output for all employees, whose HIRE_DATE before '11-May-1996'. Arrange the output by First_Name from A to Z. [6 Marks]

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

6. Design and execute a SQL query that correctly uses the CASE function and Employees table to display FIRST_NAME, the hire date is going to have four months added to it which the first Monday...

4. Using subquery, display Email, bonus with zero decimal places and name the column as "mybonus from employees table, whose managerlid is same as the employee_id of the employees, whose job id...

4. Using subquery, display first_name and the salary without decimal places and give the column name as mysalary" from f_staffs table, whose id is same as the ID of the staff whose staff_type is...

Create a new database and execute the code below in SQL Server's query window to create the database tables, CREATE TABLE Physician Specialties (Specialty.In integer, SpesialtyName varchar(5e),...

Let A, B be sets. Define: (a) the Cartesian product (A B) (b) the set of relations R between A and B (c) the identity relation A on the set A [3 marks] Suppose S, T are relations between A and B, and...

There are two problems due this week (each worth 35 points) as follows. Case 5-1David L. Miller: Portrait of a White-Collar Criminal (page 144). In comprehensive paragraphs, answerrequirements 1?6....

Assignment 1: Setting up Databases (15%) This assignment relates to the following Cowrse Learning Requirements: CLR 1 - Plan, Prepare, Install, Configure, and Use a market-leading Database Management...

DBS 3 1 1 Advanced Data Services Last update: Summer 2 0 2 4 Advanced Databae Services Assignment 1 SubmissionYour submission will be a single text - based SQL file ( . sql ) with appropriate header...

/* use these commands if you want to replace an existing version of Transit database USE master GO DROP DATABASE transit GO */ /* Homework #1 Create a database with the following tables, correctly...

Case 2 - Extreme Mountain Bikes Data Retrieval using SQL Introduction Please read the "Introduction" in Case 1 - Extreme Mountain Bikes Cost Benefit Analysis. Case 1 - Extreme Mountain Bikes Cost...

Suppose that the spin quantum number, ms, could have three allowed values instead of two. How would this affect the number of elements in the first four rows of the periodic table?

You are required to conduct a literature search and critically review a costing system in this assignment. Part A Choose ONE of the costing systems studied in this unit from the list below, and...

An investor is considering a purchase of one of the following preferred shares: ABC $ 5 0 par, 8 % cumulative preferred stock XYZ $ 5 0 par. 8 % straight preferred stock Assuming both securities are...

Scenario: A Multi-national Corporation called The Globe has created a subsidiary called Thirst in an under-developed country called non-potable waters. This hosting country suffers from a severe...

4. To what extent do you think measures of a countrys wellbeing should be included when comparing the performance of countries? Should there be something like the balanced scorecard, discussed in...

2. In your opinion do you think that measures of social performance should be considered when deciding managers pay? If so what measures should be used?

2. Obtain a copy of the safety policy for either your college or your workplace. a. Use this to identify the roles of various people in the organisation in relation to health and safety. b. Use the...