I need help...

I am having problem with those two question. Example1:
The President wishes to present watches to those employees with over 10 years experience.Print a list of these employees ranked by length of employment showing date hired, how long they have served and how many years it will take for them to reach 20 years.Show what date they will have achieved 20 years of service.This will be done with one select statement.

Example2:
The President wishes to give a rise to all employees.She has $10000 to divvy up amongst the employees in a fair and propotional way but needs some advice on how to do this.Print two charts(SELECTs )showing two options: the old and new salary should be listed and show how the $10000 was used.You decide the two methods (eg.Based on present salary or on years of service ,etc).You may use the values obtained from getting the average, sum and count as literals in your select statements.

Thank You.
Tanja Received on Mon Jul 26 1999 - 17:36:54 CDT