Answered step by step
Verified Expert Solution
Link Copied!

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:

  1. Create a report that produces the following for each employee:

earns monthly but wants . Label the column Dream Salaries.

  1. 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.

  1. 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.

  1. 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.

  1. 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

image text in transcribed

  1. 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

blur-text-image

Get Instant Access to Expert-Tailored 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

Recommended Textbook for

More Books

Students also viewed these Databases questions

Question

Identify five strategies to prevent workplace bullying.

Answered: 1 week ago