Answered step by step
Verified Expert Solution
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
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
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started