Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed

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

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions