Question: CHAPTER 6 CLASS ASSIGNMENT 2 Ch 6 Q 1 : HR needs a report of employee's and future earnings. Display the employee's full name and

CHAPTER 6 CLASS ASSIGNMENT 2
Ch6 Q1: HR needs a report of employee's and future earnings. Display the employee's full name and
salary, and their future salary increased by 20.5%(formatted for currency) for each employee who was
hired in a range of year entered by the user. The second column is the hire date, formatted as shown.
Label the columns as shown and sort by the date of hire. Only list those for the range of year desired.
That is, the user will enter two digits for the respective years. Here is the result set between 2001-2002
and 2002-2003(the user enters just the two digits, for example 01 and 02,02 and 03):
Result for Run '01' as starting year and '02' as ending year.
 CHAPTER 6 CLASS ASSIGNMENT 2 Ch6 Q1: HR needs a report

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!