Please help
From: gordan ivetic <gord001_at_sympatico.ca>
Date: Mon, 26 Jul 1999 23:13:25 GMT
Message-ID: <379D15D0.8745C3B4_at_sympatico.ca>
[Quoted] [Quoted] 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.
Date: Mon, 26 Jul 1999 23:13:25 GMT
Message-ID: <379D15D0.8745C3B4_at_sympatico.ca>
[Quoted] [Quoted] 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 Tue Jul 27 1999 - 01:13:25 CEST