Tasks:

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

earns monthly but wants . Label the column Dream Salaries.

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

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

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

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

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