Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Tasks: Create a report that produces the following for each employee: earns monthly but wants . Label the column Dream Salaries. Display each employees last
Tasks:
- Create a report that produces the following for each employee:
- Display each employees last name, hire date, and salary review date, which is the first Monday after six months of service. Label the column REVIEW. Format the dates to appear in the format similar to Monday, the Thirty-First of July, 2000.
- Display the last name, hire date, and day of the week on which the employee started. Label the column DAY. Order the results by the day of the week, starting with Monday.
- Create a query that displays the employees last names and commission amounts. If an employee does not earn commission, show No Commission. Label the column COMM.
- Using the DECODEfunction, write a query that displays the grade of all employees based on the value of the column JOB_ID, using the following data:
Job Grade
- Rewrite the statement in the preceding exercise by using the CASE syntax.
Grade Job AD PRES ST MAN IT PROG SA REE ST CLERK None of the above 0 ID GRADE 1 AC ACCOUNT 0 2 AC MGR 3 AD ASST 4 AD PRES 5 AD VP 6 AD VP 7 IT_PROG 0 14 SA_REP 15 SA REP 19 ST CLERK 20 ST MAN
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored 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